V$TEMP_SPACE_HEADER

This view 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.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the temporary tablespace
`FILE_ID`	`NUMBER`	Absolute file number
`BYTES_USED`	`NUMBER`	How many bytes are in use
`BLOCKS_USED`	`NUMBER`	How many blocks are in use
`BYTES_FREE`	`NUMBER`	How many bytes are free
`BLOCKS_FREE`	`NUMBER`	How many blocks are free
`RELATIVE_FNO`	`NUMBER`	The relative file number for the file