这个问题出现过多次,我这里的环境为solaris 64bit 9207.既然是bug.就记录一下metalink的描述吧:
|Subject:||ALERT: Wait event "ksu process alloc latch yield" After Applying 126.96.36.199 Patchset|
|Last Revision Date:||21-FEB-2006||Status:||PUBLISHED|
Oracle Server - Enterprise Edition - Version: 188.8.131.52 to 184.108.40.206
Information in this document applies to any platform.
After applying the 220.127.116.11 patchset, problems can occur due to long waits for the wait event "ksu process alloc latch yield".
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 18.104.22.168 patchset. See the list of possible symptoms for more information.
- 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
This problem is addressed in a merge patch Patch 4947798. There are no other workarounds.
Apply Patch 4947798 to resolve the issue.
21-Feb-2006 Replaced patch 4778081 with patch 4947798 as the first patch could cause errors on shutdown
Bug 4658188 - Ksu Process Alloc Latch Yield Takes 50% Db Time After 22.214.171.124
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/，如需转载，请注明出处，否则将追究法律责任。