Oracle Viewing tablespace utilization

Select Upper (f.tablespace_name)         tablespace name,       d.tot_grootte_mb                 tablespace size (M),       D.tot_grootte_mb-f.total_ BYTES "used Space (M)",       To_char (Round (d.tot_grootte_mb-f.total_bytes)/D.TOT_GROOTTE_MB *, 2), ' 990.99 ')       | | '% '                           "use ratio",       f.total_bytes                    "free Space (M)",       f.max_bytes                      "Max Block (M)" from   (select Tablespace_name ,               Round (Sum (BYTES)/(1024x768 * 1024x768), 2) total_bytes,               Round (Max (BYTES)/(1024x768 * 1024x768), 2) Max_bytes        from   SYS. Dba_free_space        GROUP  by Tablespace_name) F,       (SELECT DD. Tablespace_name,               Round (Sum (DD). BYTES)/(1024x768 * 1024x768), 2) tot_grootte_mb        from   SYS. Dba_data_files DD        GROUP by  DD. Tablespace_name) dwhere  d.tablespace_name = F.tablespace_nameorder by  1

　　

Oracle Viewing tablespace utilization