Recovery Area Space

This SQL list the recovery area size and allocation.

SELECT
  NAME,
  round((space_limit/power(1024,3)),2) LIMIT_GB ,
  round(((SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE)/Power(1024,3)),2) FREE_GB,
  ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)PERCENT_FULL
FROM
  V$RECOVERY_FILE_DEST

NAME	LIMIT_GB	FREE_GB	PERCENT_FULL
e:\oracle\fast_recovery_area	300	161,02	46,3