Skip to Main Content

SQL & PL/SQL

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!

compare tkprof

don123Apr 6 2016 — edited Apr 7 2016

Hi

I have a batch process that runs for about 10 hours. I have generated session trace for one hour and then created tkprof report.

I have generated session trace for same process for one hour on a different day then created tkprof report.

The report (txt file) is running thousands of pages when opened in MS Word.

How to compare two tkprof reports generated for a same process generated on different days to see performance issues.

Is there any common ID ? Do i need to reduce session trace to minutes instead of one hour ?

Please help me with your suggestions.

This post has been answered by vijayrsehgal-Oracle on Apr 6 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2016
Added on Apr 6 2016
7 comments
1,256 views