Hi All ;
I have some confusion. Difference between Db_flashback_retention_target vs Undo_retention.
How both are interlinked to work with flashback technology ?
DB_FLASHBACK_RETENTION_TARGET --> that defines how much flashback data Oracle has kept in the flash recovery area.
UNDO_RETENTION --> retains undo for at least the time specified in this parameter.
show parameter DB_FLASHBACK_RETENTION_TARGET;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 1400
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1