Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> DB Hit Ratio ..!!!!
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,
![]() |
![]() |