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

Home -> Community -> Usenet -> c.d.o.server -> Re: DB Hit Ratio ..!!!!

Re: DB Hit Ratio ..!!!!

From: Pat Minnis <pminnis_at_indianaonline.net>
Date: Sat, 09 Oct 1999 03:19:16 GMT
Message-ID: <UuyL3.1357$PH.106633@news.goodnet.com>


Those are some awesome numbers!
Are you 24x7 operation? Haven't shutdown in a long time perhaps? Could you have hit an upper limit on those numbers?

Ciem Mehta wrote in message <7tjkg9$tet$1_at_coco.singnet.com.sg>...
>Hi,
>
>Well, recently I found that in my V$SYSSTAT view following
>parameters were like this....
>
>db block gets 18446744069440777991
>consistent gets 18446744061222067590
>physical reads 18446744056602559685
>
>This calculation puts my DB HitRtio to 50%.
>
>And if you look at the application which is running almost the same
>speed and does not look affected as 50% Ratio.
>And I can't get the actual HitRatio..!!
>
>I am running 8.0.4.4 and 8.0.5.1 on different servers.
>(Both has the same problem suddenly...)
>
>Any Help on this will be highly appriciated.
>
>Regards,
>
>- Ciem
>
>
>
Received on Fri Oct 08 1999 - 22:19:16 CDT

Original text of this message

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