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!

How to read & interpret TKPROF output?

Ora Dev SgNov 24 2016 — edited Nov 24 2016

I am in the process of learning Oracle tuning and trying to understand how to read a TKPROF report. 

Although I have read the documentation it is not much helpful.

Here is what I have gathered from reading various blogs.

(1.) Open the TKPROF output.

(2.) Identify the query from your application that is taking most time.

(3.) Check if total elapsed time is far greater than total CPU time: If so then it means locking issues.

(4.) See the explain plan for full table scans of big tables with lots of rows.

(5.) If such found add indexes, maybe even function based indexes.

(6.) Identify if the SQL is being hard parsed many times: (How to do this???): If so then use bind variables

       and increase the size of the shared pool.

Can somebody who has experience in this give us novices general instructions like 1,2, 3, 4 etc (like above).

on how to read the TKPROF output?

A general set of instructions would suffice.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2016
Added on Nov 24 2016
4 comments
3,536 views