How Do I Find Used/free Space In A Temporary Tablespace?

1.	How Do I Find Used/free Space In A Temporary Tablespace?
Answer» 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; Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view:

Answer»

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;

Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view:

Discussion