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

Thread: help with TKProf

  1. #1
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110

    help with TKProf

    All,
    I run Tkprof as below. Why is that I dont get the sql returned in the output?
    What option is missing? I have run same and gotten sql and its plan in the past. I'm trying to get the sql that is generating ora-600. The sql is in the raw trace but is all messed up in there.

    tkprof mabo_ora_7330.trc mabo.txt explain=system/XXXXX
    table=sys.plan_tables sys=no waits=yes

    or
    tkprof mabo_ora_7330.trc mabo.txt explain=system/XXXXX sys=no waits=yes

    this is all i get

    KPROF: Release 10.2.0.3.0 - Production on Tue Dec 11 10:29:12 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Trace file: mabo_ora_7330.trc
    Sort options: execpu fchcpu
    ********************************************************************************
    count = number of times OCI procedure was executed
    cpu = cpu time in seconds executing
    elapsed = elapsed time in seconds executing
    disk = number of physical reads of buffers from disk
    query = number of buffers gotten for consistent read
    current = number of buffers gotten in current mode (usually for update)
    rows = number of rows processed by the fetch or execute call
    0 statements EXPLAINed in this session.
    ********************************************************************************
    Trace file: mabo_ora_7330.trc
    Trace file compatibility: 10.01.00
    Sort options: execpu fchcpu
    1 session in tracefile.
    0 user SQL statements in trace file.
    0 internal SQL statements in trace file.
    0 SQL statements in trace file.
    0 unique SQL statements in trace file.
    90035 lines in trace file.
    0 elapsed seconds in trace file.



    thanks
    Looking for the greatest evil in the world? Look in the mirror.

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    That means there is no SQL filred by that session during the trace period.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Quote Originally Posted by malay_biswal
    That means there is no SQL filred by that session during the trace period.
    You may be right. I did not turn on tracing expressly but I thought you could TKProf a trace generated by the system itself. Is this right?
    Looking for the greatest evil in the world? Look in the mirror.

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Yes what are you mentioned here is correct. You need to trace one session.
    http://www.perf-engg.com
    A performance engineering forum

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