Oracle TKPROF

This link will explain you what is tkprof ? how to generate tkprof?

http://www.oracle-base.com/articles/8i/TKPROFAndOracleTrace.php
http://www.oracleutilities.com/OSUtil/tkprof.html

Once you generated tkprof then you need to interpret it’s out put

http://www.adp-gmbh.ch/ora/tuning/tkprof/count_cpu_elapsed.html
http://www.adp-gmbh.ch/ora/tuning/tkprof/query_current.html


http://www.jlcomp.demon.co.uk/tkprof_01.html