Benutzer-Werkzeuge

Webseiten-Werkzeuge


dba:rac_internals

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen RevisionVorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
dba:rac_internals [2013/09/11 10:48] – [Privat IP Adress vom Interconnect] gpipperrdba:rac_internals [2014/12/05 10:49] (aktuell) gpipperr
Zeile 1: Zeile 1:
-====== RAC Internals ======+====== RAC Internals 10g ======
  
 ==== Privat IP Adress vom Interconnect ==== ==== Privat IP Adress vom Interconnect ====
Zeile 23: Zeile 23:
  
  
-==== average cr block receive time ==== +==== Die "average cr block receive time" ermitteln ====  
 + 
 +**DB:10g** 
 + 
 + 
 +Monitor the average cr block receive time since the last startup:
  
-monitor the average cr block receive time since the last startup: 
-DB:10g 
 <code plsql> <code plsql>
 SET numwidth 20 SET numwidth 20
 COLUMN "AVG CR BLOCK RECEIVE TIME (ms)" format 9999999.9 COLUMN "AVG CR BLOCK RECEIVE TIME (ms)" format 9999999.9
 SET linesize 1000 SET linesize 1000
 +
 SELECT b1.inst_id SELECT b1.inst_id
      , b2.VALUE "GCS CR BLOCKS RECEIVED"      , b2.VALUE "GCS CR BLOCKS RECEIVED"
Zeile 42: Zeile 46:
  
 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. 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