dba:rac_internals
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende ÜberarbeitungLetzte ÜberarbeitungBeide Seiten der Revision | ||
dba:rac_internals [2010/09/27 13:43] – gpipperr | dba: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, | SELECT INST_ID, | ||
</ | </ | ||
+ | |||
+ | |||
+ | Alternativ oradebug: | ||
<code plsql> | <code plsql> | ||
Zeile 14: | Zeile 18: | ||
SQL> oradebug tracefile_name | SQL> oradebug tracefile_name | ||
</ | </ | ||
- | tracefile in der USER_DUMP_DEST auswerten | ||
+ | Das Tracefile in der USER_DUMP_DEST auswerten. | ||
- | ==== average cr block receive time ==== | ||
- | monitor | + | ==== Die " |
- | DB:10g | + | |
+ | **DB: | ||
+ | |||
+ | |||
+ | Monitor | ||
<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