Skip to Main Content

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 " MAXQUERYLEN "

user13340110Aug 19 2010 — edited Aug 20 2010
My database verssion in 10.0.1.4.
OS -SUN 5.10

SQL> select max(maxquerylen) from v$undostat;

MAX(MAXQUERYLEN)
----------------
2055

=======================================
SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDORPT1

if my max query length is 2055 and undo_retention 900 . here should be error But i not getting in error . can anybody help me .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2010
Added on Aug 19 2010
7 comments
6,020 views