Totally agree with Connor. Just to add a comment to his note. A usage model recommended for UNIFORM vs. AUTOALLOCATE follows:
If you know the data volume and growth of your segments and they are predictable, then use UNIFORM. If you are completely in the dark with: 1) How much data is going to be persisted in the segments? 2) What growth patterns the segments are going to exhibit? Then use AUTOALLOCATE. Of course, if you do change your mind, after the fact, you can use the MOVE command to the tablespace of choice with the extent allocation of your choice. Cheers, Gaja --- Connor McDonald <[EMAIL PROTECTED]> wrote: > I don't believe that was the case. auto and uniform > in all of the (admittedly rudimentary and > subjective) > tests I've done appear the same in terms of > performance. > > I prefer uniform purely for the reasons of: > > - more thorough elimination of fragmentation > - predictability of next extent sizes > > hth > connor > > --- [EMAIL PROTECTED] wrote: > Hi all > > > > Some time ago there was a discussion about the use > > of the different extent > > management types and that if my memory serves me > > that there was a > > perception that Auto allocate extents had some > > performance issues against > > Uniform extents. > > > > Was this correct and can it be backed up with some > > definitive testing, has > > someone done a whitepaper??? > > > > Cheers > > > > > > -- > > ================================================= > > Peter McLarty E-mail: > > [EMAIL PROTECTED] > > Technical Consultant WWW: > > http://www.mincom.com > > APAC Technical Services Phone: +61 (0)7 3303 > > 3461 > > Brisbane, Australia Mobile: +61 (0)402 094 > > 238 > > Facsimile: +61 (0)7 > 3303 > > 3048 > > ================================================= > > A great pleasure in life is doing what people say > > you cannot do. > > > > - Walter Bagehot (1826-1877 British Economist) > > ================================================= > > Mincom "The People, The Experience, The Vision" > > > > ================================================= > > > > This transmission is for the intended addressee > only > > and is confidential > > information. If you have received this > transmission > > in error, please > > delete it and notify the sender. The contents of > > this e-mail are the > > opinion of the writer only and are not endorsed by > > the Mincom Group of > > companies unless expressly stated otherwise. > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: > > 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). > > > > ===== > Connor McDonald > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: [EMAIL PROTECTED] > > "GIVE a man a fish and he will eat for a day. But > TEACH him how to fish, and...he will sit in a boat > and drink beer all day" > > __________________________________________________ > Yahoo! Plus > For a better Internet experience > http://www.yahoo.co.uk/btoffer > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > 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). > ===== __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha 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).
