1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Problem about tkprof

Discussion in 'SQL PL/SQL' started by mak, Sep 7, 2009.

  1. mak

    mak Guest

    I want to calculate the execution time of the queries.
    I used two commands-
    alter session set timed_statistics=true;
    alter session set sql_trace=true;
    The session was altered in sql.Went to command promt & executed tkprof.
    tkprof run sucessfully but i did not get the correct output.
    i did not get the cpu time,elapsed time.
    plese help me.
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    Without seeing your tkprof-generated file it's difficult to assist you. I followed the same steps you did and I have all of the relevant information in my tkprof output. Please post sections indicating this problem so we can see what, if any, issues may exist.