Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning db_block_buffer
In article <oh2a4.874$Mk6.2115259465_at_news1.tor.primus.ca>,
"John Chiu" <johnymc_at_netscape.net> wrote:
> You have increase the sie of your data block buffer cache, it has more
> memory space to store the most recently used data ( more space for LRU
> data), thus reduce the frequency in cache out database data in the
SGA, thus
> improve the hit ratio.
>
> HTH
>
> John Chiu
>
> <mayleel_at_my-deja.com> wrote in message
news:848ds2$i0o$1_at_nnrp1.deja.com...
> > 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.
>
> Should I change the db_block_buffer back to its original setting and
make the change to the db_block_lru_latches??
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Dec 28 1999 - 09:39:14 CST