Re: Tuning db_block_buffer

Is that under the same type of load and usage?

The db_block_buffers hit ratio is greatly affected by how many repeat queries are run as opposed to ad-hoc queries - if more users are querying the system 'ad-hocly' there will not be the data they request in the buffer...

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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Dec 27 1999 - 13:58:22 CST