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
