Re: Wait Event - rdbms ipc message

From: Lei Zeng <leizeng2003_at_yahoo.com>
Date: Tue, 7 Feb 2012 14:36:40 -0800 (PST)
Message-ID: <1328654200.34146.YahooMailNeo_at_web114709.mail.gq1.yahoo.com>



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_at_att.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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 ?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 07 2012 - 16:36:40 CST

Original text of this message