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!

Not able to read Trace Files - TKPROF

Praveen PoluMay 16 2016 — edited Apr 24 2017

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

$ tkprof db01_2962.trc oralog.prf explain=scott/hr sys=no sort=prsela,exeela,fchela

$ cat oralog.prf

Capture.PNG

I want to investigate more about the ORA-Errors which I received in alertSID.log file. Thus, I referred Trace files and I used TKPROF utility but I only see this much of information in the output file. If there is no information why 2254 lines selected in a trace. What files should I look for to troubleshoot and gather more information about the issue?

Thank you in advance.

This post has been answered by Dude! on May 17 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2016
Added on May 16 2016
7 comments
1,866 views