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