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

TIA
Sanjay

Search Discussions

  • Riyaj Shamsudeen at Oct 12, 2011 at 9:10 pm
    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<http://tinyurl.com/book-expert-oracle-practices/>,
    Pro Oracle SQL, Expert PL/SQL
    Practices<http://tinyurl.com/book-expert-plsql-practices>


    On Wed, Oct 12, 2011 at 3:14 PM, Sanjay Mishra 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
  • Sanjay Mishra at Oct 13, 2011 at 3:07 am
    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@gmail.com>
    To: smishra_97@yahoo.com
    Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
    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 wrote:

    Can someone share the scripts which can be used to monitor the Private Interconnects on SQL/OS side for RAC environment
  • Sanjay Mishra at Oct 13, 2011 at 3:38 am
    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@yahoo.com>
    To: Riyaj Shamsudeen <riyaj.shamsudeen@gmail.com>
    Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
    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@gmail.com>
    To: smishra_97@yahoo.com
    Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
    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 wrote:

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 12, '11 at 8:15p
activeOct 13, '11 at 3:38a
posts4
users2
websiteoracle.com

2 users in discussion

Sanjay Mishra: 3 posts Riyaj Shamsudeen: 1 post

People

Translate

site design / logo © 2022 Grokbase