Gunther Oracle APEX und Datenbank Wiki

Diese Seite ist nicht editierbar. Sie können den Quelltext sehen, jedoch nicht verändern. Kontaktieren Sie den Administrator, wenn Sie glauben, dass hier ein Fehler vorliegt.

====== 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.