Re: tim column in trace output

From: Djordje Jankovic <djordjej_at_rogers.com>
Date: Sun, 26 Jan 2003 20:18:37 -0800
Message-ID: <F001.0053AC69.20030126201837@fatcity.com>

Thanks Mario,

That's right - at least for 8i. The values are really from v$timer, and the modulus (after which it reps) is 4294892293 which as 2+ hours less less than 497 (which is as the documentatio says).

Unfortunately for 9i the numbers in v$timer in "tim" do not fit:

SQL> select sysdate, hsecs from v$timer;

SYSDATE                  HSECS
------------------- ----------

25/01/2003 14:36:01 508345080

and the trace lines for this statement are:

PARSING IN CURSOR #3 len=34 dep=0 uid=5 oct=3 lid=5 tim=4964307423124 hv=3060113011 ad='2797f668'
select sysdate, hsecs from v$timer
END OF STMT

PARSE #3:c=10000,e=6983,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=4964307423100
EXEC #3:c=0,e=313,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=4964307423805
FETCH #3:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=4964307424193
FETCH #3:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=4964307456706

STAT #3 id=1 cnt=1 pid=0 pos=1 obj=23 op='FIXED TABLE FULL X$KSUTM '

Thanks.

Djordje

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 24, 2003 8:45 AM

> 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
> ---------------------------------------------------------------------
> 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: 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 Sun Jan 26 2003 - 22:18:37 CST