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 -> DB Hit Ratio ..!!!!

DB Hit Ratio ..!!!!

From: Ciem Mehta <chittesh_at_swi.com.sg>
Date: Fri, 8 Oct 1999 10:23:50 +0800
Message-ID: <7tjkg9$tet$1@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,

Received on Thu Oct 07 1999 - 21:23:50 CDT

Original text of this message

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