Hi,
The hit ratio on my index shows a very low value. I run the foll. query :-

select namespace, trunc(gethitratio * 100) "Hit ratio",
trunc(pinhitratio * 100) "pin hit ratio", reloads "reloads"
from v$librarycache;

I'm getting 28 for both hitratio and pinhit ratio for the Index Part. All other objects show a value above 90.

I would like to know what does it indicate -

Rewriting Application ?
Tuning/Resizing Indexes ?

Thanx