DBA_FREE_SPACE_COALESCED

DBA_FREE_SPACE_COALESCED describes statistics on coalesced space in all tablespaces in the database.


Column Datatype NULL Description

TABLESPACE_NAME

VARCHAR2(30)

 

Name of the tablespace

TOTAL_EXTENTS

NUMBER

 

Total number of free extents in the tablespace

EXTENTS_COALESCED

NUMBER

 

Total number of coalesced free extents in the tablespace

PERCENT_EXTENTS _COALESCED

NUMBER

 

Percentage of coalesced free extents in the tablespace

TOTAL_BYTES

NUMBER

 

Total number of free bytes in the tablespace

BYTES_COALESCED

NUMBER

 

Total number of coalesced free bytes in the tablespace

TOTAL_BLOCKS

NUMBER

 

Total number of free Oracle blocks in the tablespace

BLOCKS_COALESCED

NUMBER

 

Total number of coalesced free Oracle blocks in the tablespace

PERCENT_BLOCKS _COALESCED

NUMBER

 

Percentage of coalesced free Oracle blocks in the tablespace