log buffer size and log file syncs

From: CRISLER, JON A <JC1706_at_att.com>
Date: Fri, 27 Apr 2012 20:36:49 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD32501E5_at_MISOUT7MSGUSR9D.ITServices.sbc.com>

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

Original text of this message