Why is buffer cache hit rate so low??

From: <ethanpost_at_my-dejanews.com>
Date: Tue, 25 May 1999 16:09:01 GMT
Message-ID: <7iehur$1o8$1@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 - 11:09:01 CDT