log buffer size and log file syncs

  • From: "CRISLER, JON A" <JC1706@xxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • 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.

Other related posts: