Hi All,
Some times avg wait on log file sync spike on our Oracle 11.2.0.4 db. When we look at on alert log on that time
we see following messages.
Thu Nov 05 09:31:04 2020
Block recovery from logseq 1462532, block 36595759 to scn 3522018885687
Recovery of Online Redo Log: Thread 1 Group 59 Seq 1462532 Reading mem 0
Mem# 0: +REDO/xx/onlinelog/group_59.272.1047579261
Mem# 1: +REDO/xx/onlinelog/group_59.356.1047581307
Block recovery completed at rba 1462532.36596324.16, scn 820.145702968
Block recovery from logseq 1462532, block 36594513 to scn 3522018885686
Recovery of Online Redo Log: Thread 1 Group 59 Seq 1462532 Reading mem 0
Mem# 0: +REDO/xx/onlinelog/group_59.272.1047579261
Mem# 1: +REDO/xx/onlinelog/group_59.356.1047581307
Block recovery completed at rba 1462532.36596324.16, scn 820.145702967
on lgwr trace we did not see any messages.
and this ash_wait_chains output.
%This SECONDS AAS WAIT_CHAIN
------ ---------- ------- --------------------------------------------------------
32% 2985 96.3 -> log file sync -> LGWR wait for redo copy -> ON CPU
26% 2421 78.1 -> ON CPU
21% 1911 61.6 -> log file sync -> log file parallel write
Any body can help about this issue?
Regards.