select OWNER, t.segment_name, t.segment_type, sum(t.bytes / 1024 / 1024/1024) as "占用空间M" from dba_segments t where t.owner = 'RPHIS' -- and t.segment_type = 'TABLE' group by OWNER, t.segment_name, t.segment_type order by "占用空间M" desc;
查询用户下表占用空间大小
未经允许不得转载:地牯牛的博客 » 查询用户下表占用空间大小