Re: Private Interconnect Monitoring

Riyaz
Disregard the previous reply as I found that these parameter are now deprecated 
and replaced by new Parameters and so will check them
Sanjay



________________________________
From: Sanjay Mishra <smishra_97@xxxxxxxxx>
To: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, October 12, 2011 11:06 PM
Subject: Re: Private Interconnect Monitoring

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
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


Other related posts: