Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> tim column in trace output

tim column in trace output

From: Djordje Jankovic <djordjej_at_rogers.com>
Date: Fri, 24 Jan 2003 04:55:04 -0800
Message-ID: <F001.005397A0.20030124045504@fatcity.com>


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).
Received on Fri Jan 24 2003 - 06:55:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US