SELECT a.tablespace_name, round(a.bytes / 1048576) allocated_mb, round(b.free_bytes / 1048576) free_mb, ROUND(((b.free_bytes / 1048576) * 100) / (a.bytes / 1048576), 2) PERCENT_FREE FROM dba_data_files a, (SELECT file_id, SUM(bytes) free_bytes FROM dba_free_space b GROUP BY file_id) b WHERE a.file_id=b.file_id ORDER BY a.tablespace_name;
TABLESPACE_NAME ALLOCATED_MB FREE_MB PERCENT_FREE ------------------------------ ------------ ---------- ------------ ACME_DATA 100 99 98.88 ACME_INDEX 100 99 98.94 EXAMPLE 100 21 21.25 RMAN_DATA 100 93 93.44 SYSAUX 820 56 6.78 SYSTEM 740 7 .96 UNDOTBS1 360 344 95.49 USERS 5 1 17.5]]>