====== RAC Internals 10g ======
==== Privat IP Adress vom Interconnect ====
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.
==== Die "average cr block receive time" ermitteln ====
**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.