Bug 6376915 - HW enqueue contention for ASSM LOB segments (文档 ID 6376915.8) 转到底部
修改时间: 2012-7-26 类型: PATCH 状态: PUBLISHED 优先级: 3
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 affected Versions BELOW 11.2 Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)
Fixed:
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/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/17252115/viewspace-773475/
转到底部
扫一扫
1009
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
