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