nagios监控报告一台数据库服务器last_call_et超过设定阈值，等待事件为latch free。

该数据库版本为10.2.0.1，操作系统为HP-UX 11.23 IA64

查找v$session.p2，代码为127，具体latch为simulator lru latch

[@more@]

Bug 5918642 Heavy latch contention with DB_CACHE_ADVICE on

This note gives a brief overview of bug 5918642.
The content was last updated on: 01-APR-2008
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
Versions confirmed as being affected
10.2.0.3
Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in
11.2 (Future Release)
10.2.0.4 (Server Patch Set)
11.1.0.7 (Server Patch Set)

Symptoms:	Related To:
Latch Contention Waits for "latch free"	Performance Monitoring DB_CACHE_ADVICE

Description

High simulator lru latch contention can occur when db_cache_advice is
set to ON if there is a large buffer cache.


Workaround:
  Set db_cache_advice to OFF

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. Always consult with Oracle Support for advice.

References

Bug:5918642 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

ITPub博客

遭遇Bug 5918642

Bug 5918642 Heavy latch contention with DB_CACHE_ADVICE on

Affects:

Fixed:

Symptoms:

Related To:

Description

References

最新文章

*Product (Component)*	Oracle Server (Rdbms)
*Range of versions believed* to be affected**	Versions < 11.2
*Versions confirmed* as being affected**	10.2.0.3
Platforms affected	Generic (all / most platforms affected)