Daniel, To understand this better I conducted a mini-experiment. If my findings are correct then this is simpler than I thought.
Before the Oracle kernel emits a line to the 10046 trace file, it seems to check the timestamp of the last line it emitted. If more than x number of seconds have elapsed a *** timestamp line is emitted first and then the stuff that Oracle was going to put into the trace data originally. In other words, the timestamp never seems to be emitted on its own. Gudmundur ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 3:04 PM Gudmundur, Where is this documented (so I can RTFM)? The one piece of this I don't quite understand is that the timestamp is not emitted twice in a row. If the long time is the triggering event, why do I see a gap of 90 minutes (in another trace file)? Daniel Gudmundur Bjarni Josepsson wrote: > > Daniel, > > Perhaps someone else can explain this better but the documentation I've > got on this says that the Oracle kernel emits timestamps when a long > time has elapsed since the last line was emitted to the trace file. > Long time is defined as tens of seconds. > > Gudmundur > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Daniel Fink > > Sent: 22. júlí 2003 21:19 > > To: Multiple recipients of list ORACLE-L > > Subject: Timestamps in trace files > > > > > > I was perusing a 10046 trace file and I noticed that > > timestamps are written to the trace file. Sometimes they were > > very regular (3 minutes apart give or take 30 seconds) while > > other times they were hours apart. I have noticed that two > > timestamps are never written without any intervening > > activity. Anyone have any idea on the reasoning behind the > > timestamps and the 'triggering event'? > > > > Daniel > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gudmundur Bjarni Josepsson > 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: Gudmundur Josepsson 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).
