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
- Peter.McLarty_at_mincom.com 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:
> Peter.Mclarty_at_mincom.com
> 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: Peter.McLarty_at_mincom.com
>
> 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: ListGuru_at_fatcity.com (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: connor_mcdonald_at_yahoo.com
"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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Thu Apr 03 2003 - 05:03:41 CST