time counter is wrong with plsql profiler
- From: "Green Red" <heli_adrenalin@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 17 Jun 2005 11:11:05 +0000
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
Get the NEW version of MSN Messenger - it's FREE!
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: time counter is wrong with plsql profiler
- From: rjamya
Other related posts:
- » time counter is wrong with plsql profiler
- » Re: time counter is wrong with plsql profiler
- » Re: time counter is wrong with plsql profiler
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 |
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
- Re: time counter is wrong with plsql profiler
- From: rjamya