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

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