TIPS(12) : TABLE에 대하여 EXTENT 발생 량 산정 방법
=================================================

/* 모든 TABLE에 대하여 각각의 EXTENT 발생 량을 산정한다 */

set linesize 80
set pages 66
set echo off
set termout off
spool report/extent.lst

column owner no print new_value owner
break on owner page
ttitle cen 'Extent Definition Owner : ' owner skip 1 -
cen '------------------------------------------' skip 1;

col f1 format a40 heading 'OBJECT NAME'
col f2 format a10 heading 'TYPE'
col f3 format 99,999,999 heading 'TOTAL EXTS'
select a.owner owner, a.segment_name f1,
segment_type f2,
extents f3
from dba_segments a
where a.owner not in ('SYS','SYSTEM','SCOTT')
and extents > 1
/
spool off
exit