top of page

Check table size in oracle

Determine table sizes for storage management 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


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; 

Become a top notch dba with DBA Genesis
Start your DBA career today
bottom of page