col tablespace_name form a40 col free form 999,999,999 col sz form 999,999,999,999 col used form 999,999,999,999 select t.tablespace_name, d.mb sz, s.mb used, d.mb - s.mb free from sys.dba_tablespaces t, (select tablespace_name, sum(bytes)/1024/1024 MB, min(bytes)/1024/1024 smallest, avg(bytes)/1024/1024 average, max(bytes)/1024/1024 largest, count(*) num from sys.dba_free_space group by tablespace_name) f, (select tablespace_name, sum(bytes)/1024/1024 MB, sum(decode(maxbytes,0,bytes,maxbytes))/1024/1024 autoextend_MB from sys.dba_data_files group by tablespace_name) d, (select tablespace_name, sum(bytes)/1024/1024 MB from sys.dba_segments group by tablespace_name) s where t.tablespace_name = f.tablespace_name (+) and t.tablespace_name = d.tablespace_name (+) and t.tablespace_name = s.tablespace_name (+) order by 4 /