Re: DB_BLOCK_BUFFERS question

From: Wayne Balmer <wbalmer_at_wainwrights.com>
Date: 27 Jan 1999 18:20:42 GMT
Message-ID: <01be4a22$132f8f20$cc7dd826@wayneb>

You can set this value as high as will fit into initial memory.

What the instance does on startup is to allocate DB_BUFFER space by multiplying the DB_BLOCK_BUFFERS * DB_BLOCK_SIZE so if you have

	db_block_buffers=3200
	db_block_size=2048

Then in the SGA (system global area) you will allocate appx 6.4 MB of space.
The db_block_size cannot be altered after database creation so don't try, therefore your only other option is to alter the DB_BLOCK_BUFFERS parameter.

Michael L. Mason <mmason1_at_osf1.gmu.edu> wrote in article <36AF4877.5CBF_at_osf1.gmu.edu>...
> 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.
>
Received on Wed Jan 27 1999 - 12:20:42 CST