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
Letzte ÜberarbeitungBeide Seiten der Revision
dba:rac_internals [2010/09/27 13:43] gpipperrdba:rac_internals [2013/09/11 10:49] – [average cr block receive time] gpipperr
Zeile 5: Zeile 5:
 Only 10g!\\ Only 10g!\\
  
 +SQL Abfrage 10g:
 <code plsql> <code plsql>
 SELECT INST_ID,PUB_KSXPIA,PICKED_KSXPIA,NAME_KSXPIA,IP_KSXPIA FROM x$ksxpia; SELECT INST_ID,PUB_KSXPIA,PICKED_KSXPIA,NAME_KSXPIA,IP_KSXPIA FROM x$ksxpia;
 </code> </code>
 +
 +
 +Alternativ oradebug:
  
 <code plsql> <code plsql>
Zeile 14: Zeile 18:
 SQL> oradebug tracefile_name SQL> oradebug tracefile_name
 </code> </code>
-tracefile in der USER_DUMP_DEST auswerten 
  
 +Das Tracefile in der USER_DUMP_DEST auswerten.
  
  
-==== average cr block receive time ====  
  
-monitor the average cr block receive time since the last startup: +==== Die "average cr block receive time" ermitteln ====  
-DB:10g+ 
 +**DB:10g** 
 + 
 + 
 +Monitor the average cr block receive time since the last startup: 
 <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 37: 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