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;
bottom of page