select segment_type, sum(bytes)/1024/1024 MB from dba_segments where owner ='SCOTT' group by segment_type;
- 実行結果
TABLE 6.5625 INDEX 4.125
追記(2009/11/27):
全ユーザについて、ユーザ別、セグメントタイプ別に調べるSQL
select owner, segment_type, sum(bytes) bytes, sum(bytes)/1024/1024 mb from dba_segments group by owner, segment_type order by owner, segment_type;