| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
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 |
