Re: Question about the list

Thanks, I'll do that if I hit the problem again..

Tanel.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, July 27, 2003 1:54 AM

>
> 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
> > > > (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: Jared Still
> INET: jkstill_at_cybcon.com
>
> 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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).