How Do I Find Used/free Space In A Temporary Tablespace? (for Dba )

1.	How Do I Find Used/free Space In A Temporary Tablespace? (for Dba )
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:

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

Discussion