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 ???

thanks