Bug 6376915 - HW enqueue contention for ASSM LOB segments (文件 ID 6376915.8)

rongshiyuan發表於2013-09-27
原文網址 : http://blog.itpub.net/17252115/viewspace-773475/
ENQSSM
Bug 6376915 - HW enqueue contention for ASSM LOB segments (文件 ID 6376915.8)轉到底部轉到底部
修改時間:2012-7-26型別:PATCH狀態:PUBLISHED優先順序:3
沒有任何註釋註釋 (0)為此文件評級通過電子郵件傳送此文件的連結在新視窗中開啟文件可列印頁

Bug 6376915  HW enqueue contention for ASSM LOB segments

 This note gives a brief overview of bug 6376915.
 The content was last updated on: 24-FEB-2012
 Click here for details of each of the sections below.

Affects:

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

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

HW enqueue contention can occur for LOB segments which are ASSM managed
as space allocation only acquires one block at a time.
 
With this fix ASSM lobs get a minimum number of chunks based 
on the value of event 44951 (up to 1024) which should help
remove enqueue contention.
HOOKS PSE:9208 PSE:A203 "WAITEVENT:enq: HW - contention" EVENT:44951 LIKELYAFFECTS XAFFECTS_9.2.0.1 XAFFECTS_V09020001 AFFECTS=9.2.0.1 XAFFECTS_9.2.0.2 XAFFECTS_V09020002 AFFECTS=9.2.0.2 XAFFECTS_9.2.0.3 XAFFECTS_V09020003 AFFECTS=9.2.0.3 XAFFECTS_9.2.0.4 XAFFECTS_V09020004 AFFECTS=9.2.0.4 XAFFECTS_9.2.0.5 XAFFECTS_V09020005 AFFECTS=9.2.0.5 XAFFECTS_9.2.0.6 XAFFECTS_V09020006 AFFECTS=9.2.0.6 XAFFECTS_9.2.0.7 XAFFECTS_V09020007 AFFECTS=9.2.0.7 XAFFECTS_9.2.0.8 XAFFECTS_V09020008 AFFECTS=9.2.0.8 XAFFECTS_10.1.0.2 XAFFECTS_V10010002 AFFECTS=10.1.0.2 XAFFECTS_10.1.0.3 XAFFECTS_V10010003 AFFECTS=10.1.0.3 XAFFECTS_10.1.0.4 XAFFECTS_V10010004 AFFECTS=10.1.0.4 XAFFECTS_10.1.0.5 XAFFECTS_V10010005 AFFECTS=10.1.0.5 XAFFECTS_10.2.0.1 XAFFECTS_V10020001 AFFECTS=10.2.0.1 XAFFECTS_10.2.0.2 XAFFECTS_V10020002 AFFECTS=10.2.0.2 XAFFECTS_10.2.0.3 XAFFECTS_V10020003 AFFECTS=10.2.0.3 XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_BITSEG TAG_DISABLED TAG_LOB TAG_OPERF BITSEG DISABLED LOB OPERF FIXED_10.2.0.4 FIXED_11.1.0.7 FIXED_11.2.0.1 FIXED_WIN:A203P15

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:6376915 (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-773475/，如需轉載，請註明出處，否則將追究法律責任。

相關文章