Re: Optinal db_block_buffers size

aagh.
too many assumptions.

consider : 16GB of RAM . All tables and indices summed sizes < 500MB in KEEP pool.

luvverly

you will degrade performance when other potential users of the memory (and that includes Oracle - where's it going to get sort and HJ memory from ? ) are affected by your changes.

"Wells" <wshammou-(NoSpam)@optonline.net> wrote in message news:Iiay9.30648$0x.11422_at_news4.srv.hcvlny.cv.net...
> Hello all,
> Can some one please provide me the formula for determining the optimal
size
> of the db_block_buffers parameter.
> I guess what I want to know is that at what point do you actually degrade
> performance if you keep adding memory.
>
> Thank you so much,
> Wells...
>
>
Received on Wed Nov 06 2002 - 09:47:12 CST