Re: DB BLOCK BUFFERS on NT

From: Stefan Jahnke <sjahnke_at_tkc.de>
Date: Wed, 16 Jun 1999 23:13:19 +0200
Message-ID: <3768136F.7EF79C14@tkc.de>

I did the same (increased it to 16000) and it works well. I've been using this for more than a year and I didnt experience any problems. Maybe it's an older limitation and Oracle forgot to update the NT-specific documentation. But I would also be interested, wether this could cause any problems (potentially) or not.

bye
Stefan

cookr_at_nucorsteel.com wrote:

> I am running Oracle 8.0.3 on a Windows NT Server. I mistakenly changed
> by DB_BLOCK_BUFFERS parameter to 32000 vs 3200. The Database ran
> better than ever (extremely fast), but the Oracle install guide for NT
> says the maximums Buffers is 3200.
> Does anybody know if this will cause any problems or why Oracle says
> only 3200 on NT (Unix/Alpha can use many more)?
> The machine has plenty of RAM available for the SGA, and the Oracle
> instance is definitely using the extra buffers (memory size increased
> to 160MB from 65MB). I have not had any problems in a week with the
> new parameter.
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jun 16 1999 - 16:13:19 CDT