SELECT segment_name,segment_type, owner, bytes/1024/1024/1024 G FROM dba_segments WHERE tablespace_name ='SYSTEM' ORDER BY G DESC;

SELECT (SUM(BYTES)/(1024*1024*1024)) AS GB ,SEGMENT_NAME FROM DBA_SEGMENTS
where TABLESPACE_NAME  in ('SYSTEM','SYSAUX')
GROUP BY SEGMENT_NAME 
order by 1 desc;

复制

希望对你有所帮助，如有帮助，请采纳

select t.owner,t.segment_name,q.object_type,bytes/1024/1024/1024 as sizes 

from dba_segments t,dba_objects q

where t.tablespace_name='SYSTEM' and t.segment_name=q.object_name
and t.owner=q.owner
order by 4 desc;