Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Very low Index hit ratio in Library Cache

user522620Aug 22 2008 — edited Aug 24 2008

Hi
I can't find an explanation of why index hit ration is so low. Any ideas?
Thanks in advance.

SQL> SELECT namespace
  2        ,(100*gethitratio ) hit_ratio
  3    FROM v$librarycache;

NAMESPACE        HIT_RATIO
--------------- ----------
SQL AREA        96.3419062
TABLE/PROCEDURE 98.4653046
BODY            99.9739932
TRIGGER          99.884245
INDEX           46.7741935
CLUSTER         97.7272727
OBJECT                 100
PIPE                   100
JAVA SOURCE            100
JAVA RESOURCE          100
JAVA DATA              100
[pre]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2008
Added on Aug 22 2008
4 comments
1,465 views