RE: "tim=" values in Windows 2k / Oracle 9.2.0.4 trace files

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Fri, 31 Oct 2003 12:04:28 -0800
Message-ID: <F001.005D537B.20031031120428@fatcity.com>

I don't know. But it's apparently *not* a string that includes a gettimeofday value:

$ perl tim.pl 18446744069800424010
00:00:00.424010 Sunday 00 January 1900

$ perl tim.pl 1844674406980042
04:33:26.980042 Thursday 15 June 2028

$ perl tim.pl 18446744069800
07:05:44.069800 Sunday 02 August 1970

tim.pl is the program shown on p134 of "Optimizing Oracle Performance."

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney

• SQL Optimization 101: 12/8-12 Dallas
• Hotsos Symposium 2004: March 7-10 Dallas
• Visit www.hotsos.com for schedule details...

-----Original Message-----
Paul Baumgartel
Sent: Friday, October 31, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L

I haven't yet been able to figure out the "tim=" values in Win2k trace files (Oracle 9.2.0.4).

I have values such as 18446744069800424010 from a trace done a couple of days ago.

The resolution is presumably > microseconds, since the figures have 20 digits (4 more than the microsecond resolution values on Linux, so that would be, what, tenths of nanoseconds???). And I guess the Windows epoch is not the same as the Unix epoch (perish the thought). Has anyone figured out how to convert these to wall clock time values?

TIA

---

Paul Baumgartel
Transcentive, Inc.
www.transcentive.com

---

Do you Yahoo!?
Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: treegarden_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Oct 31 2003 - 14:04:28 CST