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
