ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 另类ora-4031

另类ora-4031

原创 Linux操作系统 作者:cc59 时间:2006-11-22 00:00:00 0 删除 编辑
from metalink

所谓的另类当然就是bug了.

这个问题出现过多次,我这里的环境为solaris 64bit 9207.既然是bug.就记录一下metalink的描述吧:

Subject: ALERT: Wait event "ksu process alloc latch yield" After Applying 9.2.0.7 Patchset
Doc ID: Note:343180.1Type: ALERT
Last Revision Date: 21-FEB-2006Status: PUBLISHED

In this Document
Description
Likelihood of Occurrence
Possible Symptoms
Workaround
Patches
Modification History
References


Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.7 to 9.2.0.7
Information in this document applies to any platform.

Description

After applying the 9.2.0.7 patchset, problems can occur due to long waits for the wait event "ksu process alloc latch yield".

Likelihood of Occurrence

This problem can manifest itself in several ways. Some of these problems can be seen in a RAC or non-RAC environment while ORA-4031 errors will only be seen in a RAC environment after applying the 9.2.0.7 patchset. See the list of possible symptoms for more information.

Possible Symptoms

Possible Symtoms:

- Shutdown immediate stalling
- Alert log message "PMON failed to acquire latch, see PMON dump"
- Poor DB performance due to the wait event "ksu process alloc latch yield"
- RAC Only: ORA-4031 errors due to growing "shared pool ges resources" area of the shared pool and large increases in ges_ress and ges_cache_ress in v$resource_limit

Workaround

This problem is addressed in a merge patch Patch 4947798. There are no other workarounds.

Patches

Apply Patch 4947798 to resolve the issue.

Modification History

21-Feb-2006 Replaced patch 4778081 with patch 4947798 as the first patch could cause errors on shutdown

References

Bug 4658188 - Ksu Process Alloc Latch Yield Takes 50% Db Time After 9.2.0.7
Bug 4771380 - 9207 Upgraded Rac Db - 3 Instances All Crash With Ora-4031, Core Dumps
Bug 4923667 - Ora-27300, Ora-27301, Ora-27302 Error Ocurred After Applying Patch#4778081

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/104152/viewspace-139983/,如需转载,请注明出处,否则将追究法律责任。

下一篇: rac环境中的spfile
请登录后发表评论 登录
全部评论

注册时间:2007-12-21

  • 博文量
    132
  • 访问量
    286041