From oracle-l-bounce@freelists.org Fri Jun 17 07:16:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5HCGDfU023936 for ; Fri, 17 Jun 2005 07:16:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5HCGDNi023932 for ; Fri, 17 Jun 2005 07:16:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6ACC01C014C; Fri, 17 Jun 2005 06:12:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14283-06; Fri, 17 Jun 2005 06:12:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E5B941C00D9; Fri, 17 Jun 2005 06:12:52 -0500 (EST) Message-ID: X-Originating-IP: [210.0.226.194] X-Originating-Email: [heli_adrenalin@hotmail.com] X-Sender: heli_adrenalin@hotmail.com From: "Green Red" To: oracle-l@freelists.org Subject: time counter is wrong with plsql profiler Date: Fri, 17 Jun 2005 11:11:05 +0000 Mime-Version: 1.0 Content-Type: text/html; format=flowed X-OriginalArrivalTime: 17 Jun 2005 11:11:06.0088 (UTC) FILETIME=[41942E80:01C5732D] X-archive-position: 21286 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: heli_adrenalin@hotmail.com Precedence: normal Reply-To: heli_adrenalin@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-1.9 required=5.0 tests=AWL,BAYES_00, FORGED_HOTMAIL_RCVD2,HTML_50_60,HTML_MESSAGE,MIME_HTML_NO_CHARSET, MIME_HTML_ONLY autolearn=no version=2.63
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