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