select sum(bytes)/1024/1024 from dba_segments;

查看每个表空间占用空间的大小：
select tablespace_name,sum(bytes) from dba_segments group by tablespace;