how to check flash recovery area usage on oracle 18c RAC database ?

Answer : Use below query to get flash recovery area usage on oracle 18c RAC database.

Query:


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;

Output:

NAME                 SPACE_LIMIT_GB SPACE_AVAILABLE_GB PERCENT_FULL
-------------------- -------------- ------------------ ------------
+ARHC                    7.66699219         7.64648438           .3