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