Oracle

How to check single table size in oracle

Once you run the query, it will ask your table name. Enter the table name in the format of owner.tablename. Eg – scott.emp

sql">select segment_name,segment_type, sum(bytes/1024/1024/1024) GB from dba_segments
where segment_name='&Your_Table_Name'
group by segment_name,segment_type;

 

READ ALSO
How to check last user login Oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.