7.55 DBA_TEMP_FREE_SPACE
DBA_TEMP_FREE_SPACE
displays temporary space usage information at tablespace level.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the tablespace |
|
|
|
Total size of the tablespace, in bytes |
|
|
|
Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuse |
|
|
|
Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated |
|
|
|
Type of tablespace this file belongs to:
|
|
|
|
Instance ID of the instance to which the tempfile belongs |