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.