WAIT STATISTIC NOTES

 

Coalesced Exts

WAIT STATISTIC NOTES:

Tablespace Name - Name of tablespace

Total Extents - Total number of free extents in tablespace

Extents Coalesced - Total number of coalesced free extents in tablespace

% Extents Coalesced - Percentage of coalesced free extents in tablespace

Total Bytes - Total number of free bytes in tablespace

Bytes Coalesced - Total number of coalesced free bytes in tablespace

Total Blocks - Total number of free oracle blocks in tablespace

Blocks Coalesced - Total number of coalesced free Oracle blocks in tablespace

% Blocks Coalesced - Percentage of coalesced free Oracle blocks in tablespace

select TABLESPACE_NAME,
 TOTAL_EXTENTS,
 EXTENTS_COALESCED,
 PERCENT_EXTENTS_COALESCED,
 TOTAL_BYTES,
 BYTES_COALESCED,
 TOTAL_BLOCKS,
 BLOCKS_COALESCED,
 PERCENT_BLOCKS_COALESCED
from  dba_free_space_coalesced
order  by TABLESPACE_NAME