| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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 |