Re: Timestamps in trace files

In the draft of Cary Millsap's upcoming book. You get a copy of it when you attend the Hotsos Clinic 101. Cary's supposed to be in DC right now teaching this course so I suggest he better make damn sure that he explains this properly (both there and on ORACLE-L :)

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 Wed Jul 23 2003 - 15:10:26 CDT