Some Tuning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Some Tuning

  1. #1
    Join Date
    Oct 2000
    Posts
    467
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Analyze the table and the corresponding indices and then if check the index stats. if it were to be poor then rebulid the index. If the table is fragmented, export and import the table.

    Sam

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