6.51 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

SHARED

VARCHAR2(12)

Type of tablespace this file belongs to:

  • SHARED: For shared tablespace

  • LOCAL_FOR_RIM: Local temporary tablespace for RIM (read-only) instances

  • LOCAL_FOR_ALL: Local temporary tablespace for all instance types

INST_ID

NUMBER

Instance ID of the instance to which the tempfile belongs