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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to