Re: Millsap and Timestamps in trace files

Thanks for the suggestion, Mike. I had hoped that the smiley had indicated that this was put forward in a (supposedly) humorous way. I had the great pleasure to spend some time with Cary during his stay in Iceland and I would not have posted my remark if I thought there was any danger of him being offended by it.

But again, thanks for the reminder.

Gudmundur

• Original Message ----- From: "Johnson, Michael " <Michael.Johnson_at_oln-afmc.af.mil> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, July 24, 2003 12:39 AM Subject: RE: Millsap and Timestamps in trace files

> Just lurking today ....
>
> I suspect if you ask in a more gracious and pleasant manner you may get a
> response.
>
> fwiw, Mike
>
> -----Original Message-----
> Sent: Wednesday, July 23, 2003 2:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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: 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gudmundur 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Johnson, Michael
> INET: Michael.Johnson_at_oln-afmc.af.mil
>
> 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
Received on Thu Jul 24 2003 - 02:56:51 CDT