Re: log_buffer what is the max size?

From: Andrew Babb <andrewb_at_mail.com>
Date: Sat, 01 May 1999 09:26:17 +0800
Message-ID: <372A5839.C15B9DC1@mail.com>

Ken,

You can go quite large with this, MB's, but why would you want this? In a high volume OLTP environment I ended up with 128Kb after going as high as 1Mb.

For correct settings, check the v$sysstat parameters for the 'redo log' statistics, when you have space requests, then consider increasing, or if possible activate the redo copy latches in addition to the redo allocation latch.

Rgds
Andrew

Ken wrote:

> How large a value can I have in this parameter?
>
> Thanks
> Ken
> *~~~~~~~~~~~~~~~*
> * Ken *
> * ICQ 34477742 *
> * not1.demon.co.uk *
> *~~~~~~~~~~~~~~~*
Received on Fri Apr 30 1999 - 20:26:17 CDT