-
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.
with regards
Prasanna S
-
V$SORT_SEGMENT - info about the current size of temp tablespaces
V$SORT_USAGE- sorts that are happening currently in the DB
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|