Re: db_buffer performance

On Tue, 31 Aug 2004 15:33:24 GMT, Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net> 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

db_block_buffers and db_cache_size have different units: blocks vs bytes.

I second the comment of Ganesh Raja, BCHR is a Meaningless Indicator of the Performance of the System.

--
Sybrand Bakker, Senior Oracle DBA