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

Thread: Index hit ratio is quiet low

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    10

    Exclamation Index hit ratio is quiet low

    Hi

    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?

    thanks

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

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

    HTH
    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