Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning db_block_buffer

Re: Tuning db_block_buffer

From: faith <faith_at_yahoo.com>
Date: Fri, 31 Dec 1999 18:46:21 -0800
Message-ID: <386D6A7D.FCB5B939@yahoo.com>


I've seen the same thing happen. I changed the db_block_buffer parameter on a database (8.0.5 on Solaris 2.7), and the hit ratio went from around 85% down to 70ish.
weird.

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 Fri Dec 31 1999 - 20:46:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US