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_segs1.sql
REM
REM <SQLDIR_GRP>MOST TABSP STORAGE</SQLDIR_GRP>
REM 
REM Author:
REM 	VMOGILEV Vitaliy Mogilevskiy (www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports largest segment types by owner
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_db_segs1.sql <SCHEMA_NAME>
REM 
REM Example:
REM	s_db_segs1.sql SCOTT
REM
REM History:
REM	08-01-2001	VMOGILEV	Created
REM

select segment_type, owner, sum(bytes)/1024/1024 Mbytes
from dba_segments where owner = '&owner_name'
group by owner, segment_type
order by Mbytes desc, owner, segment_type
/