Size of table by MB

Size of table by MB.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

select segment_name as table_name,
sum(bytes)/(1024*1024) table_size_MB
from user_extents
where segment_type='TABLE'
group by segment_name
order by 2 desc;