That's in 9i...in 8i it was centiseconds. --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> 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: [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).
