Re: log_buffer sizing

From: K R <kp0773_at_gmail.com>
Date: Mon, 15 Aug 2011 12:54:45 -0700
Message-ID: <CABPz0xhs4em-NGg_9sRNi1CCFvCFzhi2ou3heneft2DmejkCtg_at_mail.gmail.com>

sorry for not mentioning earlier it is on 11.2.0.2 running on solaris

On Mon, Aug 15, 2011 at 12:37 PM, Venkat Krish <venkat.lear_at_gmail.com>wrote:

> what version? Hopefully you are employing batch commits.
>
> from 11.2 docs<http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/memory.htm#PFGRF94347>
>
> *A reasonable first estimate for such systems is to the default value,
> which is:*
> * *
>
> *MAX(0.5M, (128K * number of cpus))*
>
> * *
>
> *On most systems, sizing the log buffer larger than 1M does not provide
> any performance benefit. Increasing the log buffer size does not have any
> negative implications on performance or recoverability. It merely uses extra
> memory.*
>
>
> You definitely should look for more convincing evidence (redo related wait
> events) before you go ahead and start tuning log_buffer size
>
> Regards,
> Venkat
>
>
> On Mon, Aug 15, 2011 at 3:22 PM, K R <kp0773_at_gmail.com> wrote:
>
>> All ,
>>
>> my online redo logs are 3G . This is a batch intensive datawarehouse
>> application. What should i be keeping my log_buffer .
>>
>> currently it is set at 29425664 and it just seems too low .
>>
>> thanks
>> Kart
>>
>
>

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

Received on Mon Aug 15 2011 - 14:54:45 CDT