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 |