Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
DBA_TEMP_FREE_SPACE
displays temporary space usage information at tablespace level.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace |
TABLESPACE_SIZE |
NUMBER |
Total size of the tablespace, in bytes | |
ALLOCATED_SPACE |
NUMBER |
Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuse | |
FREE_SPACE |
NUMBER |
Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated |