Bug 3797171 cache buffers chains latch contention increased in 10g-3797171.8

rongshiyuan發表於2012-12-04
AI
Bug 3797171 - "cache buffers chains" latch contention increased in 10g [ID 3797171.8]
Bug 3797171 "cache buffers chains" latch contention increased in 10g This note gives a brief overview of bug 3797171.
The content was last updated on: 03-OCT-2006
Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affectedVersions >= 10.1 but BELOW 10.2
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

  • (None Specified)

Description

 
"cache buffers chains" latch contention may be increased in 10g
over previous releases along with non uniform. use of the hash
latches.
 
Workaround
  Increase number of latches to be almost the number of hash buckets.
HOOKS "LATCH:cache buffers chains" LIKELYAFFECTS XAFFECTS_10.1.0.2 XAFFECTS_V10010002 AFFECTS=10.1.0.2 XAFFECTS_10.1.0.3 XAFFECTS_V10010003 AFFECTS=10.1.0.3 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_LATCHC TAG_PERF LATCHC PERF FIXED_10.1.0.4 FIXED_10.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:3797171 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

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

相關文章