查询每个用户所占表空间的大小

select owner,tablespace_name ,sum(bytes)/1024/1024 from dba_segments group by owner,tablespace_name;