V$TEMP_SPACE_HEADER Description: V$TEMP_SPACE_HEADER displays aggregate information per file per LOCALLY MANAGED temporary tablespace regarding how much space is currently being used and how much is free as identified in the space header.

V$TEMP_SPACE_HEADER Columns: TABLESPACE_NAME,FILE_ID,BYTES_USED,BLOCKS_USED,BYTES_FREE,BLOCKS_FREE,RELATIVE_FNO

NULL
NULL