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