REM ************************************************************************
REM Filename:	Database_Fragmentation.sql    
REM Description:
REM 	.
REM Comments:
REM
REM Modifications:
REM Author		Date	  Reason
REM Darryl B. Smith	09/01/97  Created
REM ************************************************************************
column segment_name format a22;
column owner      format a12;
column tablespace_name format a16;
column no_extents format 999;
column seg_size   format 999,999,999;
break on owner skip 1;
ttitle '                    Database Fragmentation Report ';
select owner,segment_name,tablespace_name,
         count(*) no_extents , sum(bytes) seg_size
     from sys.dba_extents
group by owner,segment_name,tablespace_name
having count(*) > 3;