怎样精确计算Oracle中表和索引的大小

Answer 1

select segment_type,segment_name, sum(bytes)/1024/1024 Mbytese
from user_segments
where segment_type in ('TABLE' ,'INDEX')
group by segment_type,segment_name order by segment_name;