col mbytes heading Mb format 999,999,999,999,999,999,999 select tablespace_name, sum(bytes)/1024/1024 mbytes from dba_free_space group by tablespace_name; /