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!

optimal value for undo_retention

546111Jun 13 2007 — edited Aug 24 2007

what is the suitable value for the undo_retention parameter for 15gb undo tablespace.I quried maxquerylen from v$undostat view which shows me 26780.Right now i set undo_retention to 20 hours.Still i am facing the ORA-01555 Error(Snapshot too old error).
Undo_management=auto
DB version 9i
OS Solaris.
Thankx...

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2007

Added on Jun 13 2007

#general-database-discussions

6 comments

3,567 views