Oracle-L: RE: tim column in trace output

From: Broodbakker, Mario <Mario.Broodbakker_at_hp.com>
Date: Fri, 24 Jan 2003 05:45:03 -0800
Message-ID: <F001.0053992B.20030124054503@fatcity.com>

Djordje,

It's hsecs from v$timer, this is what the 'db reference' says:

V$TIMER
This view lists the elapsed time in hundredths of seconds. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497 days).

regards,
Mario

-----Original Message-----
Sent: vrijdag 24 januari 2003 13:55
To: Multiple recipients of list ORACLE-L

Anybody knows what is the reference point for the timing used in the "tim" column in the trace output, like in:

PARSE #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=832261739 EXEC #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=832261739

Apparently the scale is 100 per second for 8i and 976,562.5 (1,000,000,000/1024) for 9, but I am not quite clear what could be the reference time (the time when counting of tim starts). In different databases I tried it, it is usually few months to a year back.

BTW, this column can be used if one needs to find out the exact time when a query from the trace was run.

Thanks.

Djordje

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Djordje Jankovic
INET: djordjej_at_rogers.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: Broodbakker, Mario
INET: Mario.Broodbakker_at_hp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------