I look into the V$librarycache table and I found some info but unclear so please help.
1. PINS of SQL Area=-300932440 ------ why pins is negative ??? but the GETHITRATIO is reasonable =.95
2. The GETHITRATIO on index is very poor=.281731
everything else look ok
can someone give me some hint about the above issues ???