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 )