The New Home of Oracle-wiki.net
The New Home of Oracle-wiki.net
All things oracle...
All things oracle...
A website for IT Professionals involved with Oracle database.
--
-- 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
/
Published on
Published 18th June 2025