log buffer size and log file syncs
Date: Fri, 27 Apr 2012 20:36:49 +0000
Has anybody run into a case where the log buffer size was too big, and negatively affected log file writes and log file sync waits ?
I have a system that ignores my parameter for 32mb log file size and sets it to 128mb, due to the granule size. The workaround is to lower the granule size so that I can manually set the redo log buffer lower. But I am not sure if this will have any positive affect on log file sync times. Normal I/O for log file writes is fast at 2-4 ms, but log file syncs are bad at 50 to 150 ms.Received on Fri Apr 27 2012 - 15:36:49 CDT