Re: Private Interconnect Monitoring

  • From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Wed, 12 Oct 2011 16:09:39 -0500

AWR report is a good starting point. x$ksxp_client /
dba_hist_ic_client_stats / dba_hist_ic_device_stats are some of the views
that you can query to get interconnect traffic at client/device level.

But, you really have to start in AWR report to understand global cache
workload. Then decide if your interconnect hardware is handling the traffic
well or not. Since PQ workload is captured in x$ksxp_client from 11g
onwards, you could use dba_hist_ic_client_stats view to differentiate
workload at client  level.

Of course, at OS level, netstat can be used. In Solaris, I like the script
netstatMulti in this page:


Riyaj Shamsudeen
Principal DBA,
Ora!nternals - - Specialists in Performance,
RAC and EBS11i
OakTable member

Co-author of the books: Expert Oracle
Pro Oracle SQL,  Expert PL/SQL

On Wed, Oct 12, 2011 at 3:14 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:

> Can someone share the scripts which can be used to monitor the Private
> Interconnects on SQL/OS side for RAC environment
> Sanjay
> --


Other related posts: