../E40402-16.epub /> ../E40402-16.mobi />

DBA_TEMP_FREE_SPACE

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