top of page

Check 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

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; 

Related Posts

Heading 2

Add paragraph text. Click “Edit Text” to customize this theme across your site. You can update and reuse text themes.

bottom of page