Re: log buffer

Far too small, I'd say. In the old days, having too big a redo log buffer could cause its own share of problems, but 8i introduced the 1Mb marker as a threshold for a LGWR flush, and that's therefore no longer a problem. On the other hand, there's really no need for an absolutely huge log buffer, either.

I've rarely seen a log buffer bigger than 5Mb. Most are around 1Mb. But 16K is just being a little *too* mean!!

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Sathish Balas" <sathishrani_at_home.com> wrote in message
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

>

>