SQL language for Oracle to view table space usage

Oracle reads the SQL language used to view tablespaces.

SELECT UPPER(F. TABLESPACE_NAME)"Tablespace name", D. TOT_GROOTTE_MB"Tablespace size (MB )", D. TOT_GROOTTE_MB-F. TOTAL_BYTES"Used space (M )", TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F. TOTAL_BYTES)/D. TOT_GROOTTE_MB * 100, 2 ), '1970. 99')"Usage ratio", F. TOTAL_BYTES"Free Space (M )", F. MAX_BYTES"Maximum block (M )" FROM(SELECTTABLESPACE_NAME, ROUND (SUM(BYTES) // (1024*1024), 2) TOTAL_BYTES, ROUND (MAX(BYTES)/(1024*1024), 2) MAX_BYTES FROMSYS. DBA_FREE_SPACE GROUP BYTABLESPACE_NAME) F, (SELECTDD. TABLESPACE_NAME, ROUND (SUM(DD. BYTES)/(1024*1024), 2) TOT_GROOTTE_MB FROMSYS. DBA_DATA_FILES DD GROUP BYDD. TABLESPACE_NAME) D  WHERED. TABLESPACE_NAME = F. TABLESPACE_NAME  ORDER BY4DESC;