DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2001

    SQL Area pct miss

    I found that my library cache activity for my db as follow:

    Namespace: Pct Miss:
    SQL Area 8.8
    TABLE/PROC 4.0

    is this normal? or what can I do to fix it?

    It says that pct miss should be very low like close to 1.0?

  2. #2
    Join Date
    Nov 2002
    Geneva Switzerland
    Are you using bind variables?
    What is the percentage of hard parse?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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