Re: db_buffer performance

Vince Laurent wrote:

> I have an Oracle 9.2.0.4 database. I changed a few parameters and am
> not getting HORRIBLE db_buffer hit ratios.
>
> Was:
> db_block_buffers = 250000
> db_block_size = 8192
> db_cache_size = 70000000
>
> is:
> ##db_block_buffers = 250000
> db_block_size = 8192
> db_cache_size = 80000000
>
> I thought since going to 9i I didn't need db_block_buffers.
> Ideas?
>
> Server is HP-UX 11i
> Thanks!
> Vince
> "I am mortified to be told that, in the United States of America, the sale of a book can become a subject of inquiry, and of criminal inquiry too."
> - Thomas Jefferson

Why do u want to follow Hit Ratios.. To Get a 100% or Name the Percent Hit Ratio pls visit oracledba.co.uk

Ensoy !!! :)

-- 

Cheers
Ganesh Raja
ganesh.raja_at_nospam.mantas.com
<Remove nospam to Mail>