Oracle to view data usage for all tablespaces

--View data usage for all table spacesSELECT 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)" 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, (SELECTDD. Tablespace_name,Round(Sum(DD. BYTES)/(1024x768 * 1024x768),2) TOT_GROOTTE_MB fromSYS. Dba_data_files DDGROUP   byDD. Tablespace_name) DWHERED.tablespace_name=F.tablespace_nameORDER   by 1

Oracle View data usage for all tablespaces