Performance Problems in RAC cluster 9.2.0.7 Oracle Headquarters Redwood Shores1 e1698667100526

Performance Problems in RAC cluster 9.2.0.7

A short time ago I was asked to checkout the performance of an 4 node 64 bit linux RAC cluster on 9.2.0.7 RDBMS. After a short investigation I found out that the system was waiting for a very rare wait event, called: "ksu process alloc latch yield". This wait event was comming up on all nodes (statspack and current session waits).

Looking at Metalink the issue is only mentioned as part of bug 4658188 and the wait event was introduced in 9.2.0.7. The problem is only occurring in combination with RAC, because according the bug LMON (Lock Monitor) is waiting on the event. I was able to make sure, by mapping the session waiting on the event, to the LMON process (shows up as ora_lmon_<name>).

Because of the bug the LMON process is slow and in that way the whole RAC cluster. For this issue a one of patch is available on top of 9.2.0.7 (one-off patch for Bug 4658188).

Kind Regards,

Gerwin

3 Comments

  1. Karl December 14, 2006
  2. gerwin_h December 13, 2006
  3. Jacco Landlust December 12, 2006