Skip to Main Content
Forums

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!

Undo_retention

670999Jul 20 2009 — edited Jul 25 2009
Hi experts,

I am using 10g database. I will use flashback options very often. I have set undo retention=864000 and undotablespace autoextent & mazsize unlimited. But in v$undosat view tuned_retention shows only 345600 secs.

Is undo retention has any maximum value limit???
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2009
Added on Jul 20 2009
#general-database-discussions
4 comments
1,038 views