DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TKPROF Report - Do not understand report

Threaded View

  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

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