-
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
Vinit
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|