Tuesday, August 26, 2014

oracle 10g/11g database finding table size query

select
segment_name table_name,
sum(bytes)/(1024*1024) table_size_meg
from user_extents
where segment_type='TABLE'
and segment_name = '&table_name'
group by segment_name;

No comments:

Post a Comment