I have using profiler.sql from
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=238684.1
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 :
Run |
Date |
Total Time1 |
Comment |
1 |
15-JUN-05 11:29:48 |
6484.92 |
test run test1 15 Jun 2005 |
Note 1: Total Time is in seconds
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 9.2.0.4 on HPUX 11, and compiled everything with debug.
and BTW,
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