FINDING ORACLE FLASH RECOVERY AREA USAGE SELECT NAME, (SPACE_LIMIT / 1024 / 1024 / 1024) SPACE_LIMIT_GB, ((SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE) / 1024 / 1024 / 1024) AS SPACE_AVAILABLE_GB, ROUND((SPACE_USED - SPACE_RECLAIMABLE) / SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;