Re: Why is buffer cache hit rate so low??

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 25 May 1999 15:54:17 -0400
Message-ID: <7ieuv0$r7j$1@autumn.news.rcn.net>

Hi,

You should start by looking to JDEdwards rather than Oracle as the source of your problems. Call the tech support people and see what their recommendations are.

regards

Jerry Gitomer

ethanpost_at_my-dejanews.com wrote in message <7iehur$1o8$1_at_nnrp1.deja.com>...
>All,
>
>We are running JDEdwards OneWorld on HPUX Oracle
>8 database. My buffer cache hit rate is around
>30% as opposed to recommended 85%-95%. We have
>444 Megs set up in SGA and lots of buffers.
>There are about 7 sessions that continually do a
>select from a job queue table but other than that
>I can not see what is constantly flushing the
>buffers. Where should I look for this v$sqlarea??
>
>Thanks For The Help in Advance,
>
>epost_at_xyzsafskin.com
>
>remove the xyz to send me an email directly.
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Tue May 25 1999 - 14:54:17 CDT