Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> tim column in trace output
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-LReceived on Fri Jan 24 2003 - 06:55:04 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |