'redo synch time overhead ...' statistics

From: Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
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-l
Received on Thu Dec 03 2015 - 04:28:57 CET

Original text of this message