Home » Server Options » RAC & Failsafe » Performance Deviation between RAC nodes (10.2.0.3 on RHEL 4.5)
Performance Deviation between RAC nodes [message #283154] Mon, 26 November 2007 03:55 Go to next message
arsenjew
Messages: 1
Registered: November 2007
Junior Member
Last week I encountered a strange phenomenon in a RAC cluster I'm concerned with: Some statements on node2 showed a drastically bad performance when compared to the same statements running on node2 (the AWR reports showed a ratio of 50:1 for the seconds per execution of the same statement). After node2 was restarted, performance of the two nodes was roughly the same again. From the AWRs I can see that node2 had high wait times for db file sequential read.
My expectation was that performance of one node would degrade again over time, but until now, everything looks well. I have not been able so far to identify a singular condition on node2 that might have caused the deviation: No additional jobs running, no hanging backups, nothing special in the alert logs.

Where should I turn next for my analysis of this incident? Any hint appreciated!
Re: Performance Deviation between RAC nodes [message #294758 is a reply to message #283154] Fri, 18 January 2008 23:34 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
query wait events ...as well use ASH on node 2 for those sql.
idetify cause of wait/bottleneck and start from that point.. find out what caused that wait event..there could be multifold of issues...look for every detail.

Sandeep
Previous Topic: Must OCFS2 be installed in Oracle RAC environment?
Next Topic: cluster manager does not start on node 1
Goto Forum:
  


Current Time: Thu Mar 28 13:48:52 CDT 2024