Try doubling them assuming that is not going to introduce swapping. In the
meantime try to asertain what is performing poorly. A careful analysis of
what is performing poorly will help solve the issue in the long run. by
doubling the db_block_buffers you may not be hurting anything; but you may
be delaying solving the problem. So placate them but at the same time look
more closely at what is performing poorly and why.
Jim
--
Our new email address is kennedy-family_at_home.com
Have a happy Holiday.
"bootie" <bootie_at_yahoo.com> wrote in message
news:3A46351A.4A4CADB3_at_yahoo.com...
> Oracle 8.0.5 Solaris 2.6
> I"ve recently been told (by a database engineer and upper management)
> to increase our db's db_block_buffers from 15000 to 30000!
> I've tried kicking and screaming, tried to explain that you just don't
> randomly start doubling such parameters because the hit ratio is 75%.
> They seem to think it's going to solve all performance problems, but I
> know deep down
> it's just going to cause more issues.
>
> Just wanting to rant.
>
> TIA
>
Received on Sun Dec 24 2000 - 13:57:48 CST
