Thanks SB. This looks like a sub-link of the first link I posted.
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.
Any specific link/article/doc section for this?
Best wishes to you as well (and to all of OTN).
Trace files are the input for TKPROF.
When you trace a session, a .trc file is generated, but not easy to read. TKPROF turns those files into more readable files.
I can recommend blogs/sites like asktom.oracle.com (just do a search on 10046, lots of real life explanations), Randolf Geist, Jonathan Lewis, Christian Antognini and other members of the Oaktable Network.
Differences between the various levels are the amount/depth of details that will appear in the trace.
For example: 10046 means that you'll get the wait events, 10053 (very very detailed) will give you what decisions Optimizer could have made and which one it took. (that's in minimal words )
Just like understanding Parallel Execution, getting to understand the Trace utility and how to interprete the results will require some serious reading time, so please don't rush through all the information you're getting, take one step (and subject) at a time.
Imho Morgan's Library more or less continued from psoug and is updated more frequently.