Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10046 trace data question
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
>
**************************************************************************************5
-- 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
![]() |
![]() |