Re: RE: ** log_buffer
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "ajoshi97@xxxxxxxxx" <ajoshi97@xxxxxxxxx>, "mwf@xxxxxxxx" <mwf@xxxxxxxx>, zhang410822 <zhang410822@xxxxxxx>
- Date: Wed, 23 Jul 2008 21:04:28 -0700 (PDT)
Zhang,
Thanks. The 1/2 second still sounds very long. In some time intervals it is
upto 1 second per wait. It was better till sometime back even though it was
still the highest wait event. Not known what changed but any way to find out
what is causing. Thanks
--- On Wed, 7/23/08, zhang410822 <zhang410822@xxxxxxx> wrote:
From: zhang410822 <zhang410822@xxxxxxx>
Subject: Re: RE: ** log_buffer
To: "ajoshi977@xxxxxxxxx" <ajoshi977@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>, "ajoshi97@xxxxxxxxx" <ajoshi97@xxxxxxxxx>,
"mwf@xxxxxxxx" <mwf@xxxxxxxx>
Date: Wednesday, July 23, 2008, 9:20 PM
_filtered #yiv1821395598 {
font-family:宋体;
}
_filtered #yiv1821395598 {
font-family:Verdana;
}
_filtered #yiv1821395598 {
}
_filtered #yiv1821395598 {margin:72.0pt 90.0pt 72.0pt 90.0pt;}
#yiv1821395598 P.MsoNormal {
FONT-SIZE:10.5pt;MARGIN:0cm 0cm 0pt;FONT-FAMILY:"Times New
Roman";TEXT-ALIGN:justify;}
#yiv1821395598 LI.MsoNormal {
FONT-SIZE:10.5pt;MARGIN:0cm 0cm 0pt;FONT-FAMILY:"Times New
Roman";TEXT-ALIGN:justify;}
#yiv1821395598 DIV.MsoNormal {
FONT-SIZE:10.5pt;MARGIN:0cm 0cm 0pt;FONT-FAMILY:"Times New
Roman";TEXT-ALIGN:justify;}
#yiv1821395598 A:link {
COLOR:blue;TEXT-DECORATION:underline;}
#yiv1821395598 SPAN.MsoHyperlink {
COLOR:blue;TEXT-DECORATION:underline;}
#yiv1821395598 A:visited {
COLOR:purple;TEXT-DECORATION:underline;}
#yiv1821395598 SPAN.MsoHyperlinkFollowed {
COLOR:purple;TEXT-DECORATION:underline;}
#yiv1821395598 SPAN.EmailStyle17 {
FONT-WEIGHT:normal;COLOR:windowtext;FONT-STYLE:normal;FONT-FAMILY:Verdana;TEXT-DECORATION:none;}
#yiv1821395598 DIV.Section1 {
}
#yiv1821395598 UNKNOWN {
FONT-SIZE:10pt;}
you should put the logfiles on the faster storage,or use some batch replace the
individual transaction and reduce commits.
2008-07-24
zhang410822
发件人： A Joshi
发送时间： 2008-07-24 05:58:12
收件人： oracle-l@xxxxxxxxxxxxx; ajoshi97@xxxxxxxxx; mwf@xxxxxxxx
抄送：
主题： RE: ** log_buffer
Mark,
Thanks a lot for the explanation. My main problem is log file sync. I have
very high log file sync waits (highest wait event) and it waits almost half a
second for each which I would like to reduce and I also have high log buffer
wait and it is not as high as log file sync but in the top five.
Thanks a lot.
--- On Tue, 7/22/08, Mark W. Farnham <mwf@xxxxxxxx> wrote:
From: Mark W. Farnham <mwf@xxxxxxxx>
Subject: RE: ** log_buffer
To: ajoshi977@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx, ajoshi97@xxxxxxxxx
Date: Tuesday, July 22, 2008, 1:37 PM
#yiv1821395598 UNKNOWN {
FONT-FAMILY:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv1821395598 #yiv2118933935 #yiv2118933935 P.MsoNormal {
FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"Times New Roman";}
#yiv1821395598 #yiv2118933935 LI.MsoNormal {
FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"Times New Roman";}
#yiv1821395598 #yiv2118933935 DIV.MsoNormal {
FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"Times New Roman";}
#yiv1821395598 #yiv2118933935 A:link {
COLOR:blue;TEXT-DECORATION:underline;}
#yiv1821395598 #yiv2118933935 SPAN.MsoHyperlink {
COLOR:blue;TEXT-DECORATION:underline;}
#yiv1821395598 #yiv2118933935 A:visited {
COLOR:purple;TEXT-DECORATION:underline;}
#yiv1821395598 #yiv2118933935 SPAN.MsoHyperlinkFollowed {
COLOR:purple;TEXT-DECORATION:underline;}
#yiv1821395598 #yiv2118933935 SPAN.EmailStyle17 {
COLOR:navy;FONT-FAMILY:Arial;}
#yiv1821395598 UNKNOWN {
MARGIN:1in 1.25in;}
#yiv1821395598 #yiv2118933935 DIV.Section1 {
}
#yiv1821395598 BLOCKQUOTE {
MARGIN-TOP:0px;MARGIN-BOTTOM:0px;MARGIN-LEFT:2em;}
#yiv1821395598 OL {
MARGIN-TOP:0px;MARGIN-BOTTOM:0px;}
#yiv1821395598 UL {
MARGIN-TOP:0px;MARGIN-BOTTOM:0px;}
If you’re driving log file syncs as fast as you can at a steady state of load
and you can’t keep up, then increasing log buffer won’t have a material effect
on your total throughput. In that case if you need greater throughput you need
to find a way to either do less log file syncs per unit work or a way to drain
them faster.
If your load (in this case of things that drive log file syncs) is peaked, then
increasing log buffer has the same characteristics of pushing off when you’ll
hit log buffer space waits as any other cache. Just because something starts
flushing for any given trigger doesn’t fundamentally mean more can’t be used in
parallel with the flushing. That is why these things are designed as “circular”
buffers.
Finding the exact optimal size for log_buffer is usually a fool’s errand
compared to the cost and availability of memory on today’s servers. Setting it
a little bigger than you think you need is usually cost effective. Do remember
that you can’t cut out more time from your total throughput than the time of
the log buffer space waits plus the side effect costs of the context switches
those waits cause. Log buffer space waits tend to introduce significant
avoidable costs only for batch jobs with large infrequent commits since most
other jobs will frequently yield for a commit or not need log buffer space at
all.
I hope this helps.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of A Joshi
Sent: Tuesday, July 22, 2008 12:01 PM
To: oracle-l@xxxxxxxxxxxxx; ajoshi97@xxxxxxxxx
Subject: ** log_buffer
Hi,
Is any specific formula to find the optimum log_buffer size. Any
considerations. I read that any size above 3MB might not help since it flushes
at that point anyway. Database version 9i. We are seeing high log file sync
waits and also log buffer space waits. Thanks
Other related posts:
