Re: Tuning db_block

From: Ian Jones <ijones_nspam_at_pacbell.net>
Date: Thu, 30 Dec 1999 21:30:00 -0800
Message-ID: <gmfo6s0maq4a6apr1pkfhr7rh4a1p99tak@4ax.com>

I can't see any reason why your hit ratio would drop after the increase. Could it be that the load has changed as well which is dragging down the hit ratio?

Did you change any other parameters at the same time? This makes no sense!

On Mon, 27 Dec 1999 19:21:01 GMT, mayleel_at_my-deja.com wrote:

>I'm running Oracle 8.0.5 on Solaris.
>
>I changed the db_block_buffer from 3200 to 4800,and my hit ratio went
>from 78-80% to 50% and dropping!!!
>
>Any ideas?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Dec 30 1999 - 23:30:00 CST

Re: Tuning db_block_buffer