Re: How did you size you LOG_BUFFER ??

Howard J. Rogers wrote:

> On 9 Apr 2004 04:57:15 -0700, Spendius <spendius_at_muchomail.com> wrote:
>

>> Hi,
>> Do you guys have some kind of rule to set this parameter ? [...]
>
> Sounds daft, but it's actually quite sensible: Set it to 1MB and then
> forget about it.
>
> If you later discover you are suffering from redo allocation retries or
> redo waits, then consider increasing it by a meg or two. But there's
> actually not much to worry about with the log buffer, because it gets
> flushed so frequently, it really doesn't need to be very big at all. 1MB
> is actually (usually) a little over-sized, but it won't do any harm.
>
> Regards
> HJR
Yes. Another value, which (I'm pretty sure) came from the Oracle 9.2 installation "default" (Database creation assistant) and which looks much more impressive than a simple power of 10 ;-)

        log_buffer = 655360

-Mark Bole Received on Fri Apr 09 2004 - 20:17:07 CDT