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
