How do I find used/free space in a TEMPORARY tablespace? (for DBA
ORACLE Interview Questions and Answers (Part 1)
(Continued from previous question...)
87. How do I find used/free space in a TEMPORARY tablespace? (for DBA
Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view:
SELECT tablespace_name, SUM (bytes used), SUM (bytes free)
FROM V$temp_space_header
GROUP BY tablespace_name;
(Continued on next question...)
Other Interview Questions
|