セグメント毎の使用領域を知りたい
select round(sum(bytes)/1024/1024,1) USED_MB ,round(sum(decode(substr(segment_type,1,5),'TABLE',bytes/1024/1024,0)),1) DATA_MB ,round(sum(decode(substr(segment_type,1,5),'INDEX',bytes/1024/1024,0)),1) INDEX_MB ,round(sum(decode(segment_type,'ROLLBACK',bytes/1024/1024, 0)),1) RBS_MB ,round(sum(decode(segment_type,'TEMPORARY',bytes/1024/1024, 0)),1) TEMP_MB ,round(sum(decode(substr(segment_type,1,3),'LOB',bytes/1024/1024, 0)),1) LOB_MB from dba_segments;
製品・サービスに関するお問い合わせは