Oracle 11gR1
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 | 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 |
No comments:
Post a Comment