サイズの大きいセグメントのランキングを調べるSQL

set pagesize 1000
set linesize 200
col segment_name for a50
col MB for 99999999
col extents for 99999999
select * from ( select segment_name, bytes/1024/1024 MB, extents
					from dba_segments
					where tablespace_name='USERS'
					order by bytes desc)
	where rownum <= 10;