Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RAC specific Wait events in AWR

Pete_Sg1Dec 20 2010 — edited Dec 21 2010
DB version: 10.2.0.4
OS : Solaris x86

What are the most frequent RAC specific Wait events that appear in AWR reports ?
This post has been answered by Levi Pereira on Dec 20 2010
Jump to Answer

Comments

Levi Pereira
Answer
Hi Pete,

This depends on your environment. You can identify them as follows:

Monitoring Oracle RAC Statistics and Wait Events

http://download.oracle.com/docs/cd/E11882_01/rac.112/e16795/monitor.htm#i1010220

ASH Report for Oracle RAC: Top Cluster Events

The ASH report Top Cluster Events section is part of the Top Events report that is specific to Oracle RAC. The Top Cluster Events report lists events that account for the highest percentage of session activity in the cluster wait class event along with the instance number of the affected instances. You can use this information to identify which events and instances caused a high percentage of cluster wait events.

http://download.oracle.com/docs/cd/E11882_01/rac.112/e16795/monitor.htm


Regards,
Levi Pereira
<font size="1" color="red">Please close your thread when you get the solution to your problem.</font><br>
<font size="1" color="red">Mark the replies answered "helpful" answer and/or "correct" answer that will help others with same problem.</font><br>
<font size="1" color="red">Thanks for doing your part to make this community as valuable as possible for everyone!</font><br>
Marked as Answer by Pete_Sg1 · Sep 27 2020
Pete_Sg1
Thanks Levi
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 18 2011
Added on Dec 20 2010
#performance-availability, #real-application-clusters
2 comments
598 views