You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Undo retention

Hi Team,

We specifically want to ensure that we can retain sufficient undo to perform a Flashback Table/Flashback operation for at least 24 hours.

We would like Oracle Support's expertise on the following:

Please advise whether the current UNDO tablespace size is sufficient for our workload and Flashback requirement.
Based on the available database/server storage and our workload, please provide a recommended UNDO tablespace size and appropriate UNDO_RETENTION setting to achieve this requirement.
Please also advise whether there are any other database parameters, workload characteristics, or configuration considerations that need to be addressed to reliably retain undo for the required period.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!