Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_FREE_SPACE_COALESCED

Statistics on Coalesced Space in Tablespaces 

Columns
   ___________________________
 
   TABLESPACE_NAME
      Name of Tablespace
   TOTAL_EXTENTS
      Total Number of Free Extents in Tablespace
   EXTENTS_COALESCED
      Total Number of Coalesced Free Extents in Tablespace
   PERCENT_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
   PERCENT_BLOCKS_COALESCED
      Percentage of Coalesced Free Oracle Blocks in Tablespace

Related:


Simon Sheppard
 SS64.com