9.109 V$TEMP_SPACE_HEADER
V$TEMP_SPACE_HEADER
displays aggregate information per file per LOCALLY MANAGED temporary tablespace regarding how much space is currently being used and how much is free as identified in the space header.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the temporary tablespace |
|
|
|
Absolute file number |
|
|
|
How many bytes are in use |
|
|
|
How many blocks are in use |
|
|
|
How many bytes are free |
|
|
|
How many blocks are free |
|
|
|
The relative file number for the file |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|