of course, I was selfishly thinking of this only from the perspective of the DBA and not the pocketbooks of the storage manufacturers
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > I have to respectfully disagree. Creating everything > in one huge extent and so called "defragmentation" are > extremely important and save thousands of jobs at Seagate, Conner, > Quantum, Maxtor, EMC and Hitachi. I cannot overemphasize > an importance of such policy for the healthy growth > of the storage industry. > > > -----Original Message----- > > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 28, 2002 2:30 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: storage parameters > > > > > > > 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: Gogala, Mladen > 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).
