Re: DB_FILE_MULTIBLOCK_READ_COUNT

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 27 Oct 1998 22:33:15 GMT
Message-ID: <36364955.22497470@news.siol.net>

On Tue, 27 Oct 1998 09:36:23 -0500, "Kevin Loney" <Kevin.Loney_at_astramerck.com> wrote:

> .....[SNIP].....
>Your hit ratio should be over 95 % for this instance. If it's not, then you
>should
>first make sure the environment is ok by setting the block buffers high
>enough - in a
>recent system I used block buffers 3000. PeopleSoft uses a tremendous
>number ....

3000 block buffers? This must be a typo - even with block size of 8K this would only yield less then 24 Meg of buffer cache, which is far to low for any moderately active database.

Kevin, I belive you missed a zero or two in the above number ;-)

>HTH
>Kevin.
>http://www.kevinloney.com.

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Oct 27 1998 - 16:33:15 CST