Riyaz Checking your article (http://orainternals.wordpress.com/2009/06/20/rac-parallel-query-and-udpsnoop/) and found that one of the recommendation is PARALLEL_INSTANCE_GROUP.What is best way to check and your expert view on it. Sanjay ________________________________ From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx> To: smishra_97@xxxxxxxxx Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, October 12, 2011 5:09 PM Subject: Re: Private Interconnect Monitoring Sanjay 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:http://developers.sun.com/solaris/articles/kstat_part2.html Cheers Riyaj Shamsudeen Principal DBA, Ora!nternals - http://www.orainternals.com - Specialists in Performance, RAC and EBS11i Blog: http://orainternals.wordpress.com OakTable member http://www.oaktable.com Co-author of the books: Expert Oracle Practices, Pro Oracle SQL, Expert PL/SQL Practices 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 > >TIA >Sanjay > > >-- >//www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l