执行如下语句即可： select OWNER,t.segment_name,t.segment_type,sum(t.bytes / 1024 / 1024) mmm from dba_segments t where t.owner = '你要查询的用户' and t.segment_type='TABLE' group by OWNER,t.segment_type order by mmm desc;