Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a need for setting undo_retention=0?

354513Nov 27 2008 — edited Mar 22 2010

Hi

If i set my undo_retention to a >0 value, oracle will try his best effort to keep the consistent image for as long as my undo retention value. So, i don;t see why is there a need to let oracle manage the retention for me by setting to 0.

Thanks

Rgds
Ung

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2010

Added on Nov 27 2008

#general-database-discussions

4 comments

2,641 views