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" <[EMAIL PROTECTED]> 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: [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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Broodbakker, Mario > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Djordje Jankovic 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).
