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

I hadn't noticed that ERROR lines had tim values in different units than dbcalls' tim values. I'm sure that error handling does consume CPU time. It would be difficult to consider them on par with Oracle timed events because there's no e or ela statistic associated with them. But if you can crack the mapping between ERROR tim values and dbcall tim values, then you might have something there.

I'm thinking back to when I've needed the ERROR information at all, and in the one case I can recall, it was a "user requested end of txn" kind of thing, which helped me understand that the user was doing something the DBA didn't tell me (got tired of waiting and hit Ctrl-C, basically). But I've not yet cared about how long the error-processing was taking. Sounds like you're on an interesting trail of discovery. :)

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 4/6 Seattle, 5/7 Dallas, 5/18 New Jersey

• SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego
• Hotsos Symposium 2005: March 6-10 Dallas
• Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Edgar Chupit Sent: Wednesday, March 31, 2004 4:23 AM
To: Cary Millsap
Subject: Re[2]: what exactly 'tim' means in a 10046 TRACE file ?

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
-----------------------------------------------------------------

----------------------------------------------------------------
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
-----------------------------------------------------------------