select owner, tablespace_name, sum(BYTES / 1024 / 1024) as SIZE_M
from dba_segments
group by owner, tablespace_name
order by SIZE_M desc
按照表空间进行进行group by
select owner, tablespace_name, sum(BYTES / 1024 / 1024) as SIZE_M
from dba_segments
group by owner, tablespace_name
order by SIZE_M desc
按照表空间进行进行group by