RAC Internals 10g

Only 10g!

SQL Abfrage 10g:

SELECT INST_ID,PUB_KSXPIA,PICKED_KSXPIA,NAME_KSXPIA,IP_KSXPIA FROM x$ksxpia;

Alternativ oradebug:

SQL> oradebug setmypid
SQL> oradebug ipc
SQL> oradebug tracefile_name

Das Tracefile in der USER_DUMP_DEST auswerten.

DB:10g

Monitor the average cr block receive time since the last startup:

SET numwidth 20
COLUMN "AVG CR BLOCK RECEIVE TIME (ms)" format 9999999.9
SET linesize 1000
 
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 ;

The average cr block receive time or current block receive time should typically be less than 15 milliseconds depending on your system configuration and volume, is the average latency of a consistent-read request round-trip from the requesting instance to the holding instance and back to the requesting instance.