Re: Any Comments - StatsPack Report

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Fri, 06 Apr 2007 23:15:18 GMT
Message-ID: <awARh.5326$YL5.2202@newssvr29.news.prodigy.net>

"Mladen Gogala" <mgogala.SPAM-ME.NOT_at_verizon.net> wrote in message news:pan.2007.04.05.20.01.31_at_verizon.net...
> On Thu, 05 Apr 2007 05:42:39 -0700, Charles Hooper wrote:
>
>> log buffer is a little less than 100MB
>
> Allow me to express my gratitude in the name of Kingston Technology,
> world's leading RAM manufacturer.
>
> --
> http://www.mladen-gogala.com

You know I am looking for an opinion on log buffer size. I have heard of a software vendor that suggested a 500MB log buffer, yikes.

Personally I use a 2MB redo log buffer and about 20 redo-log groups at 50MB each for a busy OLTP oriented
instance. Received on Fri Apr 06 2007 - 18:15:18 CDT