V$TEMP_EXTENT_MAP
displays the status of each unit for all LOCALLY MANAGED temporary tablespaces.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the tablespace this unit belongs to |
|
|
Absolute file number |
|
|
|
Begin block number for this unit |
|
|
|
Bytes in the extent |
|
|
|
Blocks in the extent |
|
|
|
Instance which owns this unit |
|
|
|
Relative file number |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|