Re: Question about the list

I own the list, that is, the logical entity.

Bruce Bergman is owner of the ISP, fatcity.com, and the sysadmin and mail admin.

Don't know why some posts appear before others, could be a simple explanation, could be a very complex one.

Not being a mail expert, I don't know which it is.

Best ask Bruce if you're curios - bruceb_at_fatcity.com.

Jared

On Thursday 24 July 2003 15:29, Tanel Poder wrote:
> Hi!
>
> How does the list server here operate?
> I sent a reply to one message several hours ago (see below), but it never
> reached my mailbox again. Also, sometimes I get the reply first to my
> mailbox than the original post (I mean several minutes before, it couldn't
> be a SMTP latency issue).
> Is this list moderated somehow or what could be the cause? Or could it be
> related to timestamp of sent message (My morning arrives 7-9 hours earlier
> than in US).
>
> Kind of confused,
> Tanel.
>
> ----- Original Message -----
> To: <ORACLE-L_at_fatcity.com>
> Sent: Thursday, July 24, 2003 6:06 PM
>
> > Hi!
> >
> > About the second one, you see the first read started from 6041 and was 18
> > blocks, the second one which was executed 7 minutes later, started from
>
> 6042
>
> > and was 17 blocks. Probably the extent boundary is at block 6059.
>
> Multiblock
>
> > reads don't cross extent boundaries.
> >
> > So, probably your query acquired block 6041 with FTS and by the time it
> > needed next block, the blocks were already out of buffer cache (LRU list)
> > and another multiblock read was needed. Maybe you should look at keep
>
> buffer
>
> > pool, but since the time interval was long, it might not be necessary
> > anyway...
> >
> > Tanel.
> > ----- Original Message -----
> > From: "Henry Poras" <hporas_at_etal.uri.edu>
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, July 24, 2003 6:04 PM
> > Subject: RE: Timestamps in trace files (and other trace file oddities)
> >
> > > (Tried sending this yesterday. I'll try again)
> > >
> > > Dan,
> > > I was running a 10046 (level 12) trace on an awful piece of PeopleSoft
>
> SQL
>
> > > today and got some really odd results in my trace file (8.1.7).
> > >
> > > *** 2003-07-23 15:40:59.149
> > > WAIT #1: nam='db file scattered read' ela= 0 p1=65 p2=6041 p3=18
> > > *** 2003-07-23 15:46:06.340
> > > WAIT #1: nam='latch free' ela= 1 p1=813986232 p2=66 p3=0
> > > *** 2003-07-23 15:47:53.851
> > > WAIT #1: nam='db file scattered read' ela= 0 p1=65 p2=6042 p3=17
> > >
> > > Two things struck me (three if it takes me too long to write this and I
> >
> > get
> >
> > > home late). First, the timestamps show an elapsed time of ~7 minutes,
>
> but
>
> > > the trace file has ela=1 (one onehundredth of a second). The 7 minutes
>
> is
>
> > > closer to reality. Huh???
> > >
> > > Secondly, the first scattered read reads 18 blocks starting at 6041.
> > > Why does the next scattered read start at block# 6042?
> > >
> > > Any ideas?
> > >
> > > Henry
> > >
> > >
> > >
> > > -----Original Message-----
> > > Daniel Fink
> > > Sent: Wednesday, July 23, 2003 11: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: 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: Henry Poras
> > > INET: hporas_at_etal.uri.edu
> > >
> > > 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
Received on Sat Jul 26 2003 - 17:00:33 CDT