Re: db_block_buffer

Such a radical measure usually just increases page faulting on O/S level (assuming your db_block_size is not 2k, where such a number may be adequate) If your current hitrate is 75 percent, you probably just have a badly tuned application and doubling db_block_buffers indeed is not going to resolve that.

Regards,

Sybrand Bakker, Oracle DBA

"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 - 12:31:51 CST