Verificar espaço nas tablespaces

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

SELECT F.TABLESPACE_NAME       ,TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USEDMB"       ,TO_CHAR (F.FREE_SPACE, '999,999') "FREEMB"       ,TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTALMB"       ,TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')||' %' FREE  FROM (        SELECT TABLESPACE_NAME              ,ROUND (SUM (BLOCKS*(SELECT VALUE/1024                                     FROM V$PARAMETER                                    WHERE NAME = 'db_block_size')/1024) ) FREE_SPACE          FROM DBA_FREE_SPACE         GROUP BY TABLESPACE_NAME ) F      ,(        SELECT TABLESPACE_NAME              ,ROUND (SUM (BYTES/1048576)) TOTAL_SPACE          FROM DBA_DATA_FILES         GROUP BY TABLESPACE_NAME ) T  WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME;