V$TEMP_EXTENT_MAP

This view displays the status of each unit for all LOCALLY MANAGED temporary tablespaces.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of tablespace this unit belongs to
`FILE_ID`	`NUMBER`	Absolute file number
`BLOCK_ID`	`NUMBER`	Begin block number for this unit
`BYTES`	`NUMBER`	Bytes in extent
`BLOCKS`	`NUMBER`	Blocks in extent
`OWNER`	`NUMBER`	Which instance own this unit (string)
`RELATIVE_FNO`	`NUMBER`	The relative file number