Managing FRA

The following queries are helpful in managing the FRA.

SQL> Select * from v$recovery_file_dest;

Name - Current location

Space Limit - FRA size

Space Reclaimable - Space reclaimable by deleting the obsolete files.

SQL> select * from v$flash_recovery_area_usage;

Used to check the space being used by different files and the space reclaimable by deleting the files that are obsolete.