doc

    Name:    coalescd.sql

    Author:  Mark Gurry

    The following query shows number of extents in each tablespace
    that have been coalesced. 
#

ttitle ' Coalesced Extents per Tablespace'

SELECT tablespace_name, total_extents, extents_coalesced, percent_extents_coalesced
  FROM dba_free_space_coalesced;