log file sync + log file parallel write
Radoslav Stanoev, October 11, 2016 - 2:42 pm UTC
Thanks Connor,
I have checked "log file parallel write" and it has avg of 0ms in the AWR reports.
The log file sync is 4ms per transaction and I am having 11 "user calls" per transaction.
The log switches per hour are 4 with a redo log size of 10gb.
The redo group is on SSD drives.
I do not see ant LGWR I/O issue based on the above numbers. Already removed the "alter system archive log current" command from the backups to see what will be the result.
Will let you know tomorrow how the event looks after this change.
Regards
October 12, 2016 - 3:40 am UTC
Keep us posted