vincent's Blog

SELECT a.tablespace_name, a.file_name,(a.bytes/1024/1024) "allocated(MB)", ((a.bytes-b.free_bytes)/1024/1024) "Used Space(MB)",(b.free_bytes/1024/1024) "Free(MB)",round(((b.free_bytes/a.bytes)*100),3) '%' "Free Percentage"FROM dba_data_files a,(SELECT file_id, SUM(bytes) free_bytes FROM dba_free_space b GROUP BY file_id) bWHERE a.file_id=b.file_idORDER BY a.tablespace_name;