Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: log writer tuning

RE: log writer tuning

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Wed, 21 Feb 2007 11:04:30 -0800
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0029CBE2B@ex2.ms.polyserve.com>


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
Received on Wed Feb 21 2007 - 13:04:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US