Loading
0

一起高'latch free'事件诊断解决

本文目录
[隐藏]

 

数据库版本:11.2.0.3.6 64-bit,两节点RAC环境

操作系统版本:Oracle Enterprise Linux 6.3 64-bit

其中一个节点的AWR报告中出现了高'latch free'事件,如下:

QQ图片20140210145529

查找Latch Statistics部分,发现等待来源于'KKCN reg stat latch',如下:

QQ图片20140210150125

查找MOS发现这是个BUG,MOS原文如下:

Bug 14810472  "KKCN reg stat latch" contention when HA notification enabled

This note gives a brief overview of bug 14810472.
The content was last updated on: 01-JUL-2013
Click here for details of each of the sections below.

Affects:

Product (Component)
Oracle Server (Rdbms)

Range of versions believed to be affected
(Not specified)

Versions confirmed as being affected

Platforms affected
Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:
Description

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.

 

这个BUG影响版本是11.2.0.3,当启用了HA NOTIFICATION时会出现“KKCN reg stat latch”争用,在11.2.0.4版本和12.2版本中会修复这个BUG,果断打补丁升级到11.2.0.4。

请尊重我们的辛苦付出,未经允许,请不要转载 Ask600 的文章!