DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.