====== RAC Internals 10g ======

==== Privat IP Adress vom Interconnect ====

Only 10g!\\

SQL Abfrage 10g:
<code plsql>
SELECT INST_ID,PUB_KSXPIA,PICKED_KSXPIA,NAME_KSXPIA,IP_KSXPIA FROM x$ksxpia;
</code>


Alternativ oradebug:

<code plsql>
SQL> oradebug setmypid
SQL> oradebug ipc
SQL> oradebug tracefile_name
</code>

Das Tracefile in der USER_DUMP_DEST auswerten.



==== Die "average cr block receive time" ermitteln ==== 

**DB:10g**


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

<code plsql>
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 ;
</code>

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.