Re: log buffer

From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 21 Nov 2001 01:11:18 GMT
Message-ID: <Xns915FAED96593DSunnySD@24.0.3.73>

"Sathish Balas" <sathishrani_at_home.com> wrote in news:i5tK7.24682 $Ms4.3455889_at_news1.rdc1.va.home.com:

> How do you guys decide if you want to increase the redo log buffer ?
> I have about 16K redo log buffer in an OLTP Database . The redo buffer
> allocation retries keep increasing .
> Is that enough to just increase the redo log buffer ?
>
> --
> Sathish B
>
>

For 8i+ it does no good to make the LOG_BUFFER > 3MB. I'm currently running mine at 2MB.

HTH & YMMV! Received on Tue Nov 20 2001 - 19:11:18 CST