Re: why does db_block_buffers always show 0

Anurag Varma wrote:

> "Eric" <ericw24_at_yahoo.com> wrote in message news:3ji%a.9693$kp4.1283500_at_news20.bellglobal.com...
> > Hi all,
> >
> > I set the parameter db_block_buffers in the parameter file, after restart,
> > it always shows the value is 0. The other parameters I set do show the
> > correct values. Can anyone help explain this to me? I use Oracle 9.2.0.1
> > running on Windows 2000 service pack 3.
> >
> > Eric
> >
> >
>
> db_block_buffers is a deprecated parameter. So you have db_cache_size set instead?
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch134.htm#1015750
>
> Anurag

Unless you are working with multiple block sizes in which case you need to configure db_cache_size and the caches for the additional block sizes (other than the one used by the SYSTEM tablespace).

db_2k_cache_size=?
db_4k_cache_size=?
db_8k_cache_size=?
db_16k_cache_size=?
db_32k_cache_size=?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)