How to check Flash Recovery Area Usage on oracle 18c ?

Question:How to check Flash Recovery Area Usage on oracle 18c ?

Answer :

Use below query to get Flash Recovery Area Usage on oracle 18c database.

set lines 100

col name format a60

select name,floor(space_limit / 1024 / 1024 / 1024) "Size GB",ceil(space_used / 1024 / 1024 / 1024) "Used GB" from v$recovery_file_dest order by name;

Output:

SQL> set lines 100

col name format a60

select name,floor(space_limit / 1024 / 1024 / 1024) "Size GB",ceil(space_used / 1024 / 1024 / 1024) "Used GB" from v$recovery_file_dest order by name;SQL> SQL>

NAME                    Size GB    Used GB

-------------------- ---------- ----------

+ARCH                       500        225