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. 1020dead soulision
  2. Why tell error fasing fail serial song
  3. Fair photoshop cs4 action
  4. set cfl in udf text box in sap
  5. cisco ise authentication failure
  6. centers2k
  7. barnduu
  8. clockty7
  9. tipwss
  10. whateverebb
Copyrights 2019 Fcffair BigData Resource, All rights reserved