Thanks, I'll do that if I hit the problem again.. Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED] > > 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: <[EMAIL PROTECTED]> > > 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" <[EMAIL PROTECTED]> > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
