Table space usage statistics [z]

SELECT UPPER (F.tablespace_name)"Table space Name", D.TOT_GROOTTE_MB"table space Size (M)", D.TOT_GROOTTE_MB-F.total_bytes"space Used (M)", To_char (ROUND (D.TOT_GROOTTE_MB-f.total_bytes)/D.TOT_GROOTTE_MB * -,                     2),               '990.99')"use than", F.total_bytes"free Space (M)", F.max_bytes"maximum 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) D WHERE d.tablespace_name=f.tablespace_name ORDER by4DESC;

Table space usage statistics [z]