Re: DB_BLOCK_BUFFERS question

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Thu, 28 Jan 1999 10:04:18 +0100
Message-ID: <36B02812.4546359C@Privat.Post.DE>

"Michael L. Mason" schrieb:
>
> Dear Oracle Gurus,
>
> I thought that I read somwhere in the Oracle literature that the max
> number of DB_BLOCK_BUFFERS that you could allocate is 3200. Is this
> correct? I have been looking for info on this but cannot find anything
> specifying the max.
>
> The platform is NT 4.0 Server, Oracle 7.3.3.0.0, 1 Gb memory.
>
> Thanks for your help!
> --
> The opinions expressed here are my own, and do not
> represent Unisys Corp. in any way.

DB_BLOCK_BUFFERS can be set as high as your physical mem allows. Oracle support recommends that for NT the whole SGA shouldn't excede 1/3 of the physical mem. With our dedicated server we ran at nearly 2/5-1/2.

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Thu Jan 28 1999 - 03:04:18 CST