--

-- List the Size and Quantity of Extents for a given Segment.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SET VERIFY OFF

SELECT

   bytes/1024 KB, count(*) as Count

FROM 

  dba_extents

WHERE segment_name ='&segment_name'

AND owner='&owner_name'

GROUP BY bytes/1024

ORDER BY 1

/