SET LINESIZE 85 SET PAGESIZE 200 column tablespace_name format a18 column file_name format a25 column Allocated_kb format 999,999,999 column free_kb format 999,999,999 column Percent_Free format 999 SELECT df.tablespace_name, df.file_name, df.bytes/1024 Allocated_kb, free.free_kb, Round(free.free_kb/(df.bytes/1024)*100) Percent_Free FROM dba_data_files df, (SELECT file_id, SUM(bytes)/1024 free_kb FROM dba_free_space GROUP BY file_id) free WHERE df.file_id=free.file_id ORDER BY Percent_Free;