-
Hi,
After querying the v$library cache table for the various ratios I found that my pin hit ration is very less for triggers and indexes. What should I d to fix this and what effects will it have if I just ignore it.
select namespace, gets, gethits,
2 gethitratio, pins, pinhitratio
3 from v$librarycache ;
GET HIT PIN HIT
NAME GETS GETHITS RATIO PINHITS RATIO
-------------------- --------- --------- ------- -------- -------
SQL AREA 8397 7557 .90 32263 .95
TABLE/PROCEDURE 4707 3971 .84 7365 .78
BODY 333 309 .93 333 .93
TRIGGER 69 51 .74 69 .48
INDEX 28 0 .00 28 .00
CLUSTER 371 363 .98 445 .98
OBJECT 0 0 1.00 0 1.00
PIPE 0 0 1.00 0 1.00
Thanks
Anurag
-
I don't think you have to be worried about this because the "GETS" numbers are all very small which means you don't use them much. So the RATIOs don't mean anything.
Just wait and let the numbers grow. Then the RATIOs will show the fair values.
