Index hit ratio is quiet low Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Index hit ratio is quiet low

  1. #1
    Join Date
    Feb 2002

    Exclamation Index hit ratio is quiet low


    I queried V$LIBRARYCACHE and found get_hit_ratio of namespace index is .035.
    I guess indexes are reason of my db performance degradation.

    I have already reindex all important transactional tables but get_hit_ratio of index remain around same ration.

    I would like to know
    whether simply reindexing is enough or thr is another better way to reindex?
    How do i get know which index is being corrupted?


  2. #2
    Join Date
    Oct 2002
    Breda, The Netherlands
    Did you gather statistics on your tables+indexes lately?

    You can check your index status in view "dba_indexes".

    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width