When is temp tablespace been freed?

Advertisement
November 30

Hi all
our temp tablespace is 2GB, and it is always full(100% used)
Could you tell me know
1) when temp tablespace is freed?
2) how to find out which users are using temp tablespace?
Thanks

Advertisement

Replay

1) Extents in the temp tablespace are only freed when the database is shut down. It is normal, and desirable, for your temp tablespace to show as 100% full. Allocating extents is an expensive operation. Once Oracle allocates an extent in temp, it manages them internally, re-using them as required.
2) You can use v$sort_usage to see who is using temp tablespace. However, do not be surprised if noone is using temp even if it is 100% full.
HTH
John

View 4 Replies

Tags:

  1. descargar iBooks 3.1.1 .ipa
  2. Why tell error fasing fail serial song
  3. breakpoint reached on Lenovo G 50
  4. PARNR LiVE ViDEo ON
  5. Clash of Clans vs 11.2.3
  6. print rdf oracle in new tab
  7. SAP PI CPIC-CALL: ThSAPCMRCV
  8. stepa89
  9. 65S0
  10. valuenwg
Copyrights 2019 Fcffair BigData Resource, All rights reserved