Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> high db hit ratio and a lot of waits on db sequential reads

high db hit ratio and a lot of waits on db sequential reads

From: <genegurevich_at_discover.com>
Date: Tue, 25 Sep 2007 13:57:08 -0500
Message-ID: <OF2EE30583.B0E0066D-ON86257361.0067E14C-86257361.00681B7F@discover.com>

Hi all:

I am working on tuning an app running against oracle 10.2.0.3 We have 48G on the server; my db_cache is 18G. When I look at the awr reports, I see db hit ratio being over 99% and a lot of waits for db sequential reads. Based on the SQL there are a lot of table reads based on the primary keys so that kind of waits is reasonable. But the question is if the hit ratio is that high , if we read mostly for the cache, why do we do that many reads. Is there an explanation for that?

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 25 2007 - 13:57:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US