各表の最大水位と割当量調べ
最大水位標と割当量を調べるサンプル
select t.table_name, t.blocks "最大水位標", s.blocks "割当量" from dba_tables t, dba_segments s where t.owner = 'orcl' and t.owner = s.owner and t.table_name = s.segment_name and s.segment_type = 'TABLE';
select t.table_name, t.blocks "最大水位標", s.blocks "割当量" from dba_tables t, dba_segments s where t.owner = 'orcl' and t.owner = s.owner and t.table_name = s.segment_name and s.segment_type = 'TABLE';