SQL QUERY TO FIND TOP SIZED TABLES OR SEGMENTS IN ORACLE

Use the query to find the top segments or tables in oracle database

select * from (
select segment_name,
            owner,
       bytes/1048576 MB 
from dba_segments
where owner not in ('SYS','SYSTEM')
order by 3 desc)
where rownum < 6;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s