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

I agree, I think its a software problem even though we have other things going on in the instance. My problem is that I want to see the specific SQL statements and Sessions that are blowing away my buffer cache. Here is a new twist, I am looking at V$SESS_IO to determine the hit/rate per session and the lowest hit rate I can find is 58%, but when I look at my current buffer cache hit rate for the system using v$sysstat to calculate I am around 45%, this makes no sense to me.

$r7j$1_at_autumn.news.rcn.net>,
  "Jerry Gitomer" <jgitomer_at_hbsrx.com> wrote:
> 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.---
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 18:57:52 CDT