RE: log writer tuning

usually it is "log file sync" (especially while log switch is 
performed), which is quite high, however as it is visible in excerpt 
below, log file sync is almost the same as log file parallel  write.
So I am not sure if log_buffer change will have any impact on log writer

performance - may be it would if we set log_buffer size somewhere 
between 1,5M and 0,5M, when some commits would be written down during 
background initiated writes, but we have big number of small commits, so

it is possible that most of log writes are forced by those small 

...Jaffar, you are right. Having a large redo buffer only accomodates
more piggy-back commit action, it will not somehow make lgwr wait to do
more "efficient" flushes. Quotes on purpose.



--
http://www.freelists.org/webpage/oracle-l

Other related posts: