dba:rac_internals
Inhaltsverzeichnis
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.
dba/rac_internals.txt · Zuletzt geändert: 2014/12/05 10:49 von gpipperr