dba:rac_internals
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung | ||
dba:rac_internals [2013/09/11 10:48] – [Privat IP Adress vom Interconnect] gpipperr | dba:rac_internals [2014/12/05 10:49] (aktuell) – gpipperr | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
- | ====== RAC Internals ====== | + | ====== RAC Internals |
==== 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: | ||
+ | |||
+ | |||
+ | 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