'redo synch time overhead ...' statistics
Date: Thu, 3 Dec 2015 03:28:57 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA63714D783_at_HKWPIPXMB03C.zone1.scb.net>
Apparently, v$sysstat does have statistics like
redo synch time (usec)
redo synch time overhead (usec)
redo synch time overhead count (<128 msec) redo synch time overhead count (<2 msec) redo synch time overhead count (<32 msec) redo synch time overhead count (<8 msec) redo synch time overhead count (>=128 msec)
Oracle Support note "Bug 12614085 - Diagnostic enhancement to add new statistics for investigating "log file sync" and "log file parallel write" relationship (Doc ID 12614085.8)" talks of an enhancement that enables this collection but I am not sure I understand it.
Can anyone interpret that note and help me understand that statistics ? If I see the overhead time being reported by these statistics, what really (what overhead) does it represent ? What if we have DataGuard in the picture ? Does it also reflect DataGuard LGWR SYNC overheads ?
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 03 2015 - 04:28:57 CET