Re: Timestamps in trace files

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 ----- From: "Daniel Fink" <daniel.fink_at_sun.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 23, 2003 3:04 PM Subject: Re: Timestamps in trace files

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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: gbj_at_index.is
>
> 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 Thu Jul 24 2003 - 05:22:13 CDT