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