Re: How did you size you LOG_BUFFER ??

On Sat, 10 Apr 2004 01:17:07 GMT, Mark Bole <makbo_at_pacbell.net> wrote:

>
> 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

It certainly wins on the sexiness stakes, Mark!!

Incidentally, what would you do when confronted with a student who innocently asks "Is my 200MB Log Buffer too small?"

For the record, I called an immediate tea break and had 6 smokes.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================