Benutzer-Werkzeuge

Webseiten-Werkzeuge


dba:rac_internals

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.

Cookies helfen bei der Bereitstellung von Inhalten. Durch die Nutzung dieser Seiten erklären Sie sich damit einverstanden, dass Cookies auf Ihrem Rechner gespeichert werden. Weitere Information
"Autor: Gunther Pipperr"
dba/rac_internals.txt · Zuletzt geändert: 2014/12/05 10:49 von Gunther Pippèrr