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