How to read the result of TKPROF
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to read the result of TKPROF

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    How to read the result of TKPROF

    We are trying to figure out some performance issue .
    This is the summary from trprof

    Does it mean that the total sql execution time is
    elapsed(NON-RECURSIVE)+elapsed(RECURSIVE) = 2.96 +0.28=3.24 sec?



    ********************************************************************************

    OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 310 0.20 2.59 0 0 0 0
    Execute 310 0.11 0.35 0 246 447 142
    Fetch 96 0.00 0.00 0 538 0 157
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 716 0.31 2.96 0 784 447 299

    Misses in library cache during parse: 92


    OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 145 0.05 0.25 0 0 0 0
    Execute 145 0.03 0.02 1 146 442 145
    Fetch 0 0.00 0.00 0 0 0 0
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 290 0.08 0.28 1 146 442 145

    Misses in library cache during parse: 5

    310 user SQL statements in session.
    145 internal SQL statements in session.
    455 SQL statements in session.
    ********************************************************************************
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    Re: How to read the result of TKPROF

    Originally posted by ligang

    Does it mean that the total sql execution time is
    elapsed(NON-RECURSIVE)+elapsed(RECURSIVE) = 2.96 +0.28=3.24 sec?
    It means the database spent 3.24 seconds working on it. However, your session may have been connected longer and waiting for the client. Oracle 9i (9.2 at least) has a section of tkprof that shows what you were waiting on. I suggest you use that.
    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."

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Is it possible to tell what option should be used in TRPROF to display the waiting time?

    We are using oracle9.2 above
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Try set events 10046 level 12 and use Trace Analyzer whilst contected as the person who created the trace file.

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