DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: tkprof

  1. 03-21-2005, 05:45 PM #1
    knm_dibba
    knm_dibba is offline Junior Member
    Join Date
    Dec 2004
    Posts
    9

    tkprof

    OS=Linux
    Oracle version: 9.2.0.4

    I have a 1.02gb trace file. when i do a tkprof on the trace file, its hung.
    It does not error out but keeps running without giving any output. I waited for atleast one hour and then killed the tkprof process. even after one hour the outputfile is 0 Bytes.

    any ideas.

    thanks in advance.
    Reply With Quote Reply With Quote
  2. 03-21-2005, 07:33 PM #2
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    maybe u can split it to smaller filess
    split -1000 filename
    Reply With Quote Reply With Quote
  3. 03-21-2005, 07:38 PM #3
    Axr2
    Axr2 is offline Senior Advisor
    Join Date
    Oct 2002
    Posts
    807
    A metalink note suggests that you use mknod and pipe the trace file (like an import) to tkprof. Folks say it works. I've never tried it on tkprof though..
    Reply With Quote Reply With Quote
  4. 03-21-2005, 07:42 PM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by kris123
    maybe u can split it to smaller filess
    split -1000 filename

    err no, chances are you will split the STAT lines all up and make a hash of it
    Reply With Quote Reply With Quote
  5. 03-21-2005, 08:53 PM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Is it using CPU?
    Jeff Hunter
    Reply With Quote Reply With Quote
  6. 03-21-2005, 10:16 PM #6
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    I has the same problem looking at a trace file where tkrpof took more then 2gb in memory on my windooze server and then killed itself. I could not find a work around but check it's mem utilization to see if that is the problem
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  7. 03-22-2005, 04:02 AM #7
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    What is the motive to see tkproof o/p..?

    * long running qry?
    * resource usage?

    you can fix these problems without even tkproof... cant u?

    Rgds
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  8. 03-22-2005, 11:50 AM #8
    knm_dibba
    knm_dibba is offline Junior Member
    Join Date
    Dec 2004
    Posts
    9

    tkprof - finished

    i tried again and this time left it to run. it took 2 hours to finish.
    the outputfile was 445MB.
    Used TOP to monitor and the CPU and memory usage were normal.
    this tkprof process was the top session in TOP. the values of VIRT and RES columns in TOP were increasing during the run. from this i was assured TKPROF was doing something.

    i tried also the mknod method(as suggested in metalink) and it took even more time(> 3 hours) to finish.
    Reply With Quote Reply With Quote
  9. 03-22-2005, 11:58 AM #9
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You should turn on sql_trace for a single session not the whole database. Once you turn on tracing for a single session go through and do all of the transactions that seem slow, turn off tracing for that session then use tkprof, it should be much smaller. I'm not sure off hand how to turn on tracing for a single session, you might look it up under tahiti.oracle.com
    Reply With Quote Reply With Quote
  10. 03-22-2005, 12:08 PM #10
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    dbms_system.set_sql_trace_in_session(sid, serial#, false) will turn it off

    or set_ev if using a 10046 trace
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width