11.1.0.7 row cache lock 修改用户名密码 bug 7715339

This note gives a brief overview of bug 7715339.
 The content was last updated on: 27-JUL-2011
 Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions >= 11.1
Versions confirmed as being affected	11.1.0.7
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

11.2.0.1 (Base Release)

Symptoms:	Related To:
Performance Affected (General) Waits for "row cache lock"	Security ( Authentication / Privileges / Auditing )

Description

In 11g there is an intentional delay between allowing failed logon
attempts to retry. For some specific application types this can cause
a problem as the row cache entry is locked for the duration of the
delay . This can lead to excessive row cache lock waits for DC_USERS .

This "fix" allows the logon delay to be disabled in 11.2.0.1 onwards
by setting event 28401 in the init.ora.
eg:
    event="28401 trace name context forever, level 1" # disable logon delay.
This "event" will disable the logon sleep delay system-wide, 
ie. it will affect all user accounts, system-wide, and so should be used
    with extreme caution as it makes the database more vulnerable to
    logon attacks.

Note: 
 One off fixes for this issue for 11.1.0.7 do not need an event set -
 interim patches for 11.1 disable the delay unconditionally.

Work Around:
 Ensure the correct password is used - especially for connection 
 intensive logons

 

HOOKS "WAITEVENT:row cache lock" EVENT:28401 LIKELYAFFECTS XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XAFFECTS_11.1.0.7 XAFFECTS_V11010007 AFFECTS=11.1.0.7 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_PERF TAG_SEC PERF SEC FIXED_11.2.0.1

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:7715339 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22034023/viewspace-708156/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22034023/viewspace-708156/