SQL Area pct miss
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Area pct miss

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    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
    Location
    Geneva Switzerland
    Posts
    3,142
    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