Is there a query that can help me determine if my temp tablespace is empty or not? If there is can any one show me?
Thank you,
dorothy
Printable View
Is there a query that can help me determine if my temp tablespace is empty or not? If there is can any one show me?
Thank you,
dorothy
The TEMP tablespace is used whe memory is not enough for sorting, indexing and analyzing objects. Once the job is done, the segments are empty only.
U can use DBA_EXTENTS to see how many extents allocated in that tablespace or DBA_FREE_SPACE to check what r the free extents in that tablespace.
V$SORT_SEGMENT - info about the current size of temp tablespaces
V$SORT_USAGE- sorts that are happening currently in the DB