select occupant_desc, space_usage_kbytes 
from v$sysaux_occupants
where space_usage_kbytes > 0
order by space_usage_kbytes desc
/

col Mb form 9,999,999  
col SEGMENT_NAME form a40  
col SEGMENT_TYPE form a6  
set lines 120  
select sum(bytes/1024/1024) Mb, segment_name,segment_type from dba_segments  
where  tablespace_name = 'SYSAUX'  
and segment_name like 'WRI$_OPTSTAT%'  
and segment_type='TABLE'  
group by segment_name,segment_type order by 1 asc 
/






col Mb form 9,999,999  
col SEGMENT_NAME form a40  
col SEGMENT_TYPE form a6  
set lines 120  
select sum(bytes/1024/1024) Mb, segment_name,segment_type from dba_segments  
where  tablespace_name = 'SYSAUX'  
and segment_name like '%OPT%'  
and segment_type='INDEX'  
group by segment_name,segment_type order by 1 asc  
/