FLASH RECOVERY AREA (FRA)

Configure

sql > alter system set db_recovery_file_dest_size = 2G scope=both sid='*';
sql > alter system set db_recovery_file_dest='+ORAFLASH001' scope=both sid='*';

sql > show parameter db_reco

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +ORAFLASH001
db_recovery_file_dest_size big integer 2G


Check space utilization

summary

col name format a20
select * from v$recovery_file_dest;

details

select * from v$flash_recovery_area_usage;