Ratio Differnce from pc & server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ratio Differnce from pc & server

  1. #1
    Join Date
    Aug 2001
    Posts
    87

    Cool

    Hi,

    I have different hit ratios when i run my script from my
    PC (SQLPlus) and when i run it from the Server (SQLPlus)

    Can any one tell me why ?
    and which one is correct

    regards


  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    How did you calculate the hitratio??? (mostta people use stupid logic to find hitratio) Can you post your query?? and Can you post the hitratios you got when you run from different machines?? When did you run the script?? at what time??? You might have got the blocks from buffer cache when you run the script 2nd time... check it out..

    -nagarjuna

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