I believe that it's microseconds since the Unix epoch (1/1/1970
00:00:00 UTC).
--- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> Does anyone know where tim= comes from? Is it from a certain epoch?
>
> e.g.
> PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5
> tim=1042250821743271 hv=1053795750 ad='1eed99f0'
> COMMIT
> END OF STMT
> PARSE
> #15:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1042250821743266
> XCTEND rlbk=0, rd_only=1
> EXEC
> #15:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1042250821743458
> =====================
> PARSING IN CURSOR #1 len=2882 dep=1 uid=5 oct=47 lid=5
> tim=1042250821743528 hv=3326928535 ad='16ff4a88'
>
>
> I am writing a program that takes a trace file and reconstructs the
> whole trace against a timeline. My first run looks like this ... As
> you can see, because this is first pass, I ma skipping a lot of
> details. Those will eventually come in ... don't know how yet ... my
> imagination is running wild.
>
> 2003-10-27 09:27:21.465000 Session Started.
> 2003-10-27 09:27:21.465000 PARSE
> Cursor#15 [ 0 microseconds]
> 2003-10-27 09:27:21.465192 EXEC
> Cursor#15 [ 192 microseconds]
> 2003-10-27 09:27:21.465259 EXEC
> Cursor#1 [ 67 microseconds]
> 2003-10-27 09:27:21.466318 PARSE
> Cursor#1 [ 1059 microseconds]
> 2003-10-27 09:27:21.466642 PARSE
> Cursor#8 [ 324 microseconds]
> 2003-10-27 09:27:21.466721 EXEC
> Cursor#8 [ 79 microseconds]
> 2003-10-27 09:27:21.467023 FETCH
> Cursor#8 [ 302 microseconds]
> 2003-10-27 09:27:21.467099 PARSE
> Cursor#9 [ 76 microseconds]
> 2003-10-27 09:27:21.469147 EXEC
> Cursor#9 [ 2048 microseconds]
> 2003-10-27 09:27:21.469228 EXEC
> Cursor#1 [ 81 microseconds]
> 2003-10-27 09:27:21.473288 PARSE
> Cursor#1 [ 4060 microseconds]
>
> although I am doing all calculations by hand, it would be nice to
> know where tim= is coming from ....
>
> any ideas?
>
> If you are curious why I am doing this? We get emails when users
> experience delays that are (or deemed) unacceptable. Next day we take
> the trace file and try to look at it, but without a good timeline it
> is difficult to find that a user did between 10:15am and 10:20am.
> That's why I am writing this program.
>
> Raj
>
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
>
>
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
> you.
>
**************************************************************************************5
>
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.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 Wed Oct 29 2003 - 16:34:25 CST
