RAC Tuning the Interconnect

Script to Collect RAC Diagnostic Information (racdiag.sql) (Doc ID 135714.1)

set linesize 10000
SET lines 200
SELECT b1.inst_id, b2.VALUE "GCS CR BLOCKS RECEIVED",
     b1.VALUE "GCS CR BLOCK RECEIVE TIME",
     ((b1.VALUE / b2.VALUE) * 10) "AVG CR BLOCK RECEIVE TIME (ms)"
     FROM gv$sysstat b1, gv$sysstat b2
     WHERE b1.name = 'global cache cr block receive time'
     AND b2.name = 'global cache cr blocks received'
     AND b1.inst_id = b2.inst_id OR b1.name = 'gc cr block receive time'
     AND b2.name = 'gc cr blocks received'
     AND b1.inst_id = b2.inst_id;

http://blog.yannickjaquier.com/oracle/rac-interconnect-traffic.html
http://www.colestock.com/blogs/2008/02/rac-tuning-inter-connect.html
http://vishaloracle.blogspot.in/2009/02/estimated-interconnect-traffic-kb.html
http://oracle-info.com/2013/05/13/rac-cluster-interconnect-performance-troubleshooting-quick-reference/
http://gjilevski.com/2011/08/02/oracle-cache-fusion-private-inter-connects-and-practical-performance-management-considerations-in-oracle-rac/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s