V$TEMP_EXTENT_MAP

V$TEMP_EXTENT_MAP displays the status of each unit for all LOCALLY MANAGED temporary tablespaces.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the tablespace this unit belongs to
`FILE_ID`	`NUMBER`	Absolute file number
`BLOCK_ID`	`NUMBER`	Begin block number for this unit
`BYTES`	`NUMBER`	Bytes in the extent
`BLOCKS`	`NUMBER`	Blocks in the extent
`OWNER`	`NUMBER`	Instance which owns this unit
`RELATIVE_FNO`	`NUMBER`	Relative file number