Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: what exactly 'tim' means in a 10046 TRACE file ?

Re[2]: what exactly 'tim' means in a 10046 TRACE file ?

From: Edgar Chupit <chupit_at_tsi.lv>
Date: Wed, 31 Mar 2004 13:23:21 +0300
Message-ID: <31855406.20040331132321@tsi.lv>


Hello Cary,

CM> The fortunate thing is that it's rarely necessary to be able to convert CM> a tim into a wall time and vice versa.

But how should we treat ERROR lines in trace files, for example on 9iR2 I have this lines in trace file:

EXEC #31:c=0,e=3083,p=0,cr=9,cu=17,mis=0,r=1,dep=1,og=4,tim=1055355471165039 ERROR #31:err=24381 tim=694217847

As I understood from your book and metalink first time is in hsecs and second time is in msecs.

How should I compare this two times? simply convert two tim values to wall clock and subtract values or somehow differently?

Can I treat ERROR lines as wait events, because as I saw from some tests ERROR handling consumes some amount of cpu time?

--

 Edgar



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Mar 31 2004 - 04:19:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US