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-----
From: Gudmundur Josepsson [mailto:gbj_at_index.is] Sent: Wednesday, July 23, 2003 2:10 PM
To: Multiple recipients of list ORACLE-L Subject: 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 ----- 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