Timing a Procedure/package using tkprof

Has anyone used tkprof to carry out performance tuning on packages and procedures out there?

I am having trouble trying to find the total (elapsed) time spent in a procedure. Tkprof does not give the cumulative time spent executing the procedure. Has anyone found a was/method to achieve this?

Also does anyone know why tkprof' summary totals does not include non-resursive time.

For example. If I had 2 procedures

package.proc_A

        SQL_statment 1
package.proc_B

        SQL_statement_2

If it took 5 seconds each to execute statment 1 & 2 and say 2 seconds each to execute the other parts of the procedure, then the total elapsed time is

(2+5) + (2+5) = 14 seconds

Tkprof's summary totals only report 4 secods which is the non-recusive statements.

Has anyone written their own utility to interpret the trace files?

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-2536173
 \_______/                  |Email:TJambu_at_wizard.com.au PHONE: +61-3-2536385