Ah. I think that the kernel will only emit a timestamp line immediately before writing a db call or wait event to the trace data. This is a similar trigger to the one that the kernel uses for writing a PARSING IN CURSOR (PIC) section to the trace stream. You'll only see the PIC section immediately preceding a database call line. You'll see timestamps immediately preceding either a database call line or a WAIT line.
Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Washington, Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- Daniel Fink Sent: Wednesday, July 23, 2003 10:04 AM To: Multiple recipients of list ORACLE-L 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: Cary Millsap 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).
