Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Understanding trace and tkprof -

915396Dec 25 2013 — edited Dec 25 2013

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 )

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 22 2014
Added on Dec 25 2013
5 comments
299 views