If in Oracle 9i or 10g the undo_retention parameter is set to 900 sec and after that period if unexpired (uncommitted) data is overwritten by other transactions in some undo segment, then how does rollback work in that case? As undo has been overwritten which was supposed to be used for rollback?
Oracle will not overwrite the rollback information for uncommitted transactions, even if the UNDO_RETENTION time has passed. Oracle will overwrite this information only for
committed transactions. So if a transaction runs for longer than 900 seconds in your example, you will still be able to rollback that transaction.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.