Whoops! Sorry about that one, listers! Made the usual mistake with "reply" button...
That was intended for Jay Earle, who is east of Maine and west of Nova Scotia and 'way north of the Mason-Dixon line... ----- Original Message ----- To: <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 8:08 AM > We're one game away from beating the Red Wings; how are the Maple Leafs > doing? I haven't been paying attention... > > ...the Red Wings are the better coached and are just the better team, but > the Avs are showing enough grit to take the lead in the series. Gotta love > it... > > ----- Original Message ----- > From: "Jay Earle (DBA)" <[EMAIL PROTECTED]> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, May 28, 2002 1:03 PM > Subject: RE: storage parameters > > > > Hi Fazia, > > > > I would recommend the following white paper, it advocates using the SAFE > > methodology. > > > > HOW TO STOP DEFRAGMENTIING AND START LIVING > > Bhaskar Himatsingka, Oracle Corporation > > & Juan Loaiza, Oracle Corporation > > > > > > > > You can find the paper on Cary Millsap's site. www.hotsos.com > > > > > > > > Sincerely, > > > > Jay > > > > > > Jay Earle, BSc(CS) ([EMAIL PROTECTED]) > > DBA, Operations Group > > SmartForce, Learning Solutions for the Human Enterprise > > -----Original Message----- > > Sent: Tuesday, May 28, 2002 3:30 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > An example: Think of load a lot of data into a table, and then load > > > on a very limited basis. This tells me to create a large first > > >extent that everything can fit into. > > > > why? there is no benefit to that > > > > > > --- basher 59 <[EMAIL PROTECTED]> wrote: > > > No. I can think of several reason when you would not wan them the > > > save. > > > An example: Think of load a lot of data into a table, and then load > > > on a > > > very limited basis. This tells me to create a large first extent > > > that > > > everything can fit into. Example: Say 100M and then you may want > > > to make > > > next extents 5M. Based on the fact that you won't be reaching the > > > second > > > extent for a while. > > > > > > Also the temp tablespace is used to sort. I had an instance where > > > the > > > sorts were taking a long time. I looked at the temp tablespace and > > > found > > > out that my current sort was using 300 extents of a very small size. > > > I > > > increase my extent size to a large number, where the sort only took 4 > > > > > > extents and it really speeded up my sort. To optimize everything I > > > look at > > > the majority of my sorts and tried to make my first entent give me 90 > > > % of > > > these sorts. Which was somewhat small, and then I made my next > > > extents > > > large enough so my largest sort did not use more than about (5 to 10) > > > > > > extents. > > > > > > MN > > > > > > > > > >From: "Malik, Fawzia" <[EMAIL PROTECTED]> > > > >Reply-To: [EMAIL PROTECTED] > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > >Subject: storage parameters > > > >Date: Tue, 28 May 2002 08:18:37 -0800 > > > > > > > > > > > >Hi, > > > > > > > >Does Oracle reccommend having the initial and next extents set at > > > the same > > > >values??? > > > >I am tidying up a current schema and the values are non uniform all > > > the way > > > >through- any comments would be very much appreciated > > > > > > > >Rgds > > > > > > > >Fawzia > > > > > > > > > > > > > >********************************************************************** > > > >Information in this email is confidential and may be privileged. > > > >It is intended for the addressee only. If you have received it in > > > error, > > > >please notify the sender immediately and delete it from your system. > > > >You should not otherwise copy it, retransmit it or use or disclose > > > its > > > >contents to anyone. > > > >Thank you for your co-operation. > > > > > >********************************************************************** > > > > > > > >-- > > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > >-- > > > >Author: Malik, Fawzia > > > > INET: [EMAIL PROTECTED] > > > > > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > >San Diego, California -- Public Internet access / Mailing > > > Lists > > > >-------------------------------------------------------------------- > > > >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). > > > > > > > > > _________________________________________________________________ > > > Get your FREE download of MSN Explorer at > > > http://explorer.msn.com/intl.asp. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: basher 59 > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing > > > Lists > > > -------------------------------------------------------------------- > > > 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). > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! - Official partner of 2002 FIFA World Cup > > http://fifaworldcup.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > 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.com > > -- > > Author: Jay Earle (DBA) > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
