This content has been marked as final. Show 2 replies
I think those online documentations will help you;
By the way, have you recently decreased the db_flashback_retention_target parameter's value?
Yes, db_flashback_retention_target is actually just that - target minimum log retention time which Oracle will try to satisfy. If there is more space in the FRA available, Oracle will happily store more flashback logs than it needs to satisfy the target. There is no explicit way to delete flashback logs, they will eventually be deleted automatically as FRA fills up and Oracle will need to free some space in it. You can force this cleanup by lowering db_recovery_file_dest_size so that FRA will appear full and then setting it to original value after the cleanup is complete.