Doc

Name: OBJ_FRAG.sql

Author: Mahnho Han

Information what is the objects which is occured extents many times

#

SET LINESIZE 130

SET PAGESIZE 80

COLUMN OWNER FORMAT A16

COLUMN SEGMENT_NAME FORMAT A30

COLUMN TYPE FORMAT A8

COLUMN EXTENTS FORMAT 999

COLUMN TS_NAME FORMAT A10

COLUMN MAX_EXTENTS HEADING 'MAX|EXTENTS' FORMAT 999

COLUMN INI_EXT HEADING 'INITIAL|EXTENT(KB)' FORMAT 99,999,999

COLUMN NXT_EXT HEADING 'NEXT|EXTENT(KB)' FORMAT 99,999,999

COLUMN PCT_INCREASE HEADING 'PCT|INCR' FORMAT 999

SELECT OWNER,SEGMENT_NAME,SEGMENT_TYPE TYPE,EXTENTS,MAX_EXTENTS,

BLOCKS,INITIAL_EXTENT/1024 INI_EXT,

NEXT_EXTENT/1024 NXT_EXT,PCT_INCREASE,TABLESPACE_NAME TS_NAME

FROM DBA_SEGMENTS

WHERE EXTENTS > &EXTENTS

ORDER BY EXTENTS DESC;