Querying Oracle Tablespace Usage

1 SELECT UPPER(F.tablespace_name) Tablespace name, D.TOT_GROOTTE_MB table space 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) "2    from(SELECTTablespace_name,ROUND(SUM(BYTES)/(1024x768 * 1024x768),2) Total_bytes,ROUND(MAX(BYTES)/(1024x768 * 1024x768),2) max_bytes fromSYS. Dba_free_spaceGROUP  bytablespace_name) F,3(SELECTDd. Tablespace_name,ROUND(SUM(DD. BYTES)/(1024x768 * 1024x768),2) TOT_GROOTTE_MB fromSYS. Dba_data_files DDGROUP  byDD. Tablespace_name) D4  WHERED.tablespace_name=F.tablespace_name5  ORDER  byF.tablespace_name;