查看某个数据库所有用户已使用的表空间大小情况

select sum(GB),owner from (select segment_name,bytes/1024/1024/1024 as GB,owner from dba_segments  order by bytes desc ) group by owner order by sum(GB) desc