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

It appears to be fairly close to the value of GetTickCount (the number of milliseconds since boot). However, obviously GetTickCount is measured in milliseconds whereas tim in Oracle 9 increments by microseconds. Also from first look, tim is slightly larger than GetTickCount*1000 on my current system. I'll do a bit more inestigating.

At 01:04 PM 10/31/2003, you wrote:
>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

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.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).