11.1.0.7 row cache lock 修改使用者名稱密碼 bug 7715339

wei-xh發表於2011-09-23

This note gives a brief overview of bug 7715339.
 The content was last updated on: 27-JUL-2011
 Click 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
Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

  • Waits for "row cache lock"

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

(This link will only work for PUBLISHED bugs)
Information on the sections in this article

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22034023/viewspace-708156/,如需轉載,請註明出處,否則將追究法律責任。

相關文章