-
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
-
Analyze the table and the corresponding indices and then if check the index stats. if it were to be poor then rebulid the index. If the table is fragmented, export and import the table.
Sam
