Re: why does db_block_buffers always show 0

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F40F5D3.8597D774_at_exxesolutions.com...
> pectodectryl wrote:
>
> > Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message
news:<3F3ED56F.9A08C78_at_exxesolutions.com>...
> > > 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.ht m#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=?
> >
> > What?
> >
> > In the first place, the requirement to set db_cache_size is not
> > dependent on whether you have the odd-sized block parameters set.
> > DB_BLOCK_BUFFERS is deprecated whether you set them or not. Hence, to
> > suggest that you only 'need to configure db_cache)size' when you are
> > 'working with multiple block sizes' is wrong.
> >
> > In the second place, db_cache_size affects not only the block size of
> > SYSTEM, but also of TEMP (or whatever you decide to call your
> > temporary tablespace).
> >
> > Yours in flight
> > Pectodectryl
>
> Thanks for the clarification. How about UNDO?
>
> --
> 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)
>
>

Maybe I'm missing the point .. but what exactly is this debate about? If you are not working with multiple block sizes, you only need to configure db_cache_size (and not the cb_nk_cache_size(s)). And if you set both db_block_buffers and db_cache_size in your init.ora, your
db won't start because these two are incompatible. And: if you just set db_block_buffers, then it should come into effect (Have not tried it,
but documentation seems to state that).

Anurag Received on Mon Aug 18 2003 - 14:28:11 CDT