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