I have using profiler.sql from
and am noticed all the timings even it was stated on the report to be seconds, much longer than the wall clock time,
e.g. I ran a stored proc for 15 seconds
and the time shows :
Note 1: Total Time is in seconds
||test run test1 15 Jun 2005|
which is like more than one hour!
same thing happen to the whole report.
Just wonder if this is a bug with the profiler package or I had missed something?
I am using 126.96.36.199 on HPUX 11, and compiled everything with debug.
I wish to know if there is a way to deliver a report of how much time was spent on SQL and how much on PL/SQL code?
Rgds & Thx