Recovery Area Config
alter system set db_recovery_file_dest_size=2G scope=both;
alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=both;
alter system set db_flashback_retention_target=1440 scope=both;
select * from v$recovery_file_dest;
select * from v$flash_recovery_area_usage;
select current_scn from v$database;
select * from v$flashback_database_log;
page revision: 2, last edited: 08 May 2009 13:06