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 |