Re: Wait Event - rdbms ipc message
- From: Lei Zeng <leizeng2003@xxxxxxxxx>
- To: "JC1706@xxxxxxx" <JC1706@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Feb 2012 14:36:40 -0800 (PST)
Jon:
Have you checked with ASH report to see which session is/was waiting on this
event? Or, whether this wait event is related to specific application user,
module, or sql id, object, etc.?
Wait event is just one dimension when we examine the databaseâ??s performance
data. From wait event, you can drill down to other dimensions like session,
application, sql, sql plan, etc. Usually, if we see one dimension stands out
(wait event in this case), we can check other dimensions for either
corresponding symptoms, or explanations.
If you donâ??t have time to write queries to explore AWR/ASH views, please feel
free to try DBspeed http://www.dbspeed.com/product.html
DBspeed provides lots of the data mining queries for AWR/ASH. You can use it
create AWR/ASH report and browse it directly. Very easy to use.
Lei
http://www.dbspeed.com/index.html
________________________________
From: "CRISLER, JON A" <JC1706@xxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, February 7, 2012 7:56 AM
Subject: Wait Event - rdbms ipc message
Oracle RAC 11g, AWR reports shoes the metric "rdbms ipc message" as the #1 in
Top 5 wait events.
I have to admit I don't think I have seen this before, and I am not sure where
to look-
11gR2 on Red Hat Linux 5 64 bit, ASM to SAN.Â
Any suggestions ?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
