set linesize 200; col owner for a18; col segment_name for a28; select owner,segment_name,sum(bytes / 1024 / 1024) segment_size from dba_segments where segment_name = upper('table_name') group by owner,segment_name;
select owner, sum(bytes / 1024 / 1024 / 1024) segment_size from dba_segments where segment_name in (select d.object_name from dba_objects d where d.object_type = 'TABLE') group by owner order by 2 desc;
发表评论