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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,004 views