RE: what exactly 'tim' means in a 10046 TRACE file ?

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 30 Mar 2004 23:03:45 -0600
Message-ID: <003601c416dd$8e94dac0$6601a8c0@CVMLAP02>

It's the time, in microseconds, at which the parse call completed.

On Win2k it's going to be difficult for you to convert this time back and forth to something that looks like wall clock time. The only way I know to do it is to establish an equivalence between some datestamp line (beginning with '***') and a tim value that's proximal to it. Then every time a tim advances x microseconds, advance your mental wall clock by the same amount. Every time you see a new "*** <timestamp>" line, increment your mental tim clock by the same amount as the wall clock moved forward.

The fortunate thing is that it's rarely necessary to be able to convert a tim into a wall time and vice versa. The only thing you typically need a tim for is time consumption that's relative to that of another line in the trace file.

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]
Sent: Tuesday, March 30, 2004 10:42 PM
To: Freelists
Subject: what exactly 'tim' means in a 10046 TRACE file ?

Hi List,

i would like to know what exactly
'tim' value means in a '10046 event'
trace file. (9iR2 on W2K)

for example , what this means ?
PARSE #1: tim=31028556368

is it the time(micro seconds) taken
to parse ? (i don't think so.the query
did not take so much time)
OR
is it the system time when the parse
was done ? if so,how do i interpret it
to a readable time format ?

with Cary's book in front of me,i still
can't get exactly what it is :(

Regards,
Prem.

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 Tue Mar 30 2004 - 23:03:01 CST