Bug 10018789 Spin in kgllock / DB hang with high library cache lock waits on ADG

This note gives a brief overview of bug 10018789.
The content was last updated on: 03-SEP-2013
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.2.0.2 but BELOW 12.1
*Versions confirmed* as being affected**	11.2.0.2 11.2.0.1
Platforms affected	Generic (all / most platforms affected)

It is believed to be a regression in default behaviour thus:
Regression introduced in 11.2.0.2

Fixed:

This issue is fixed in	12.1.0.1 (Base Release) 11.2.0.3 (Server Patch Set) 11.2.0.2.2 Database Patch Set Update 11.2.0.2 Bundle Patch 1 for Exadata Database 11.2.0.1 Bundle Patch 7 for Exadata Database 11.2.0.2 Patch 25 on Windows Platforms 11.2.0.2 Patch 3 on Windows Platforms
Symptoms:		Related To:
Hang (Process Spins) ORA-1555 Waits for "library cache lock"		Active Dataguard (ADG)

Description

This problem is introduced in 11.2.0.2 by the fix for bug 9214531

A self-hang / spin can occur when getting a library cache lock

leading to a wider hang scenario with other sessions waiting

for the blocked lock.

Rediscovery Notes:

A process spins in kglLock(),

other processes waiting for the spinning session

ORA-1555 on Active data Guard

HOOKS ERROR:ORA-1555 SPIN:kglLock "WAITEVENT:library cache lock" CAUSE:9214531 SUPERCEDES:9214531 LIKELYAFFECTS XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_ADG TAG_HANG/SPIN TAG_RB202 TAG_REGRESSION ADG HANG/SPIN RB202 REGRESSION FIXED_11.2.0.1.BP07 FIXED_11.2.0.2.2 FIXED_11.2.0.2.BP01 FIXED_11.2.0.3 FIXED_12.1.0.1 FIXED_WIN:B202P03 FIXED_WIN:B202P25

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:10018789 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

ITPub博客

Oracle active dataguard ORA-01555

最新文章