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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
