5 Replies Latest reply: Dec 25, 2013 9:26 AM by ranit B RSS

    Reg: Understanding trace and tkprof -

    ranit B

      Hi Experts,

       

      First of all -- Wish all of you a Merry Christmas. May god bless all.


      I want to understand the tracing utility i.e. trace files and I assume they are the output of tkprof utility.

       

      Searched and got this doc link - Using Application Tracing Tools

      Or this - http://www.dba-oracle.com/t_reading_oracle_trace_files.htm

      Or this - http://www.oracle-base.com/articles/8i/tkprof-and-oracle-trace.php

       

      Which of these will be a good point to start, or any other article/link ?

       

      Also, I have heard different types of traces like 10046, 10086, and so... What is the difference between these?

      Can you please explain this in quick minimal words? Just for an overview and rest I will read.

       

      Please help me understand this.

       

      -- Ranit

      ( on Oracle 11.2.0.3.0 )