SQL QUERY TO FIND TOP SEGMENTS IN SYSTEM TABLESPACE IN ORACLE

SQL QUERY TO FIND TOP SEGMENTS IN SYSTEM TABLESPACE IN ORACLE

Use this query to find top segments occupied in system tablespace

select * from
(select segment_name,
             bytes/1073741824 GB,
             segment_type
from
dba_segments
where tablespace_name='SYSTEM'
order by 2 desc)
where rownum < 6;

Leave a Reply

%d bloggers like this: