Ask the Expert

Does Oracle overwrite rollback information for uncommitted transactions?

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?

    Requires Free Membership to View

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.

This was first published in June 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: