TKPROF Report - Do not understand report
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TKPROF Report - Do not understand report

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    TKPROF Report - Do not understand report

    1. Could someone help me make sense of the report. I am not clear on what to make sense of when the:

    Parse and Execute = 33
    but the Misses in library cache during parse = 0.

    call count cpu elapsed disk query current rows
    ------- ---- --- ------ ----- ----- ------- ----
    Parse 33 0.00 0.00 0 0 0 0
    Execute 33 0.00 0.05 0 66 331 33
    Fetch 0 0.00 0.00 0 0 0 0
    ------- ---- ---- ---- ---- ---- ----- ----
    total 66 0.00 0.05 0 66 331 33

    Misses in library cache during parse: 0
    Optimizer goal: CHOOSE
    Parsing user id: 21

    2. Also I have put an attachment, could anyone give me a breif on what can be inmproved from the tkprof report.
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    1. You are essentially "soft parsing"..since your Misses=0. You aren't hard parsing. So don't be overly concerned. If you don't know the difference see asktom, metalink, technet etc

    2. Nice try. If you have a specific problem/issue, state the same. I'm not gonna pore over your tkprof output and recommend solutions! It's like someone posting a statspack report..and open endedly asking for suggestions! Yeah right..

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This means that you parsed the query every time you executed. My guess is you are updating in a loop and explicitly parsing and executing in each iteration of the loop. Explicitly parsing every query will limit your scalability and overburdens your CPU.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Nov 2001
    Posts
    110
    What is the difference between "soft parse" and "hard parsing". How can soft parsing be avoided.

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