REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_db_ext2.sql
REM
REM <SQLDIR_GRP>SEGMENT MOST</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports segments close to their maxextents parameter
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_db_ext2.sql
REM 
REM Example:
REM	s_db_ext2.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM

set lines 132
set trims on

column name format a35
column type format a10

SELECT owner||'.'||SEGMENT_NAME NAME
,  SEGMENT_TYPE TYPE
,  EXTENTS
,  MAX_EXTENTS
,  MAX_EXTENTS - EXTENTS LEFT_EXTENTS
,  NEXT_EXTENT/1024 next_kb
,  bytes/1024 bytes_kb
FROM       DBA_SEGMENTS
WHERE      MAX_EXTENTS - EXTENTS < &extents_limit
AND        MAX_EXTENTS > 0
ORDER BY SEGMENT_TYPE
,  SEGMENT_NAME;