Re: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g
From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 4 Mar 2011 07:53:21 -0800
Message-ID: <AANLkTin4+vwuUAYBbkw89BXvH4dwH2PuUQhTuxKPYjX2_at_mail.gmail.com>
I'd would recommend AUTOALLOCATE over UNIFORM unless you require very large extents (>64MB). If require larger extents for a segment, just use the INITIAL attribute.
Date: Fri, 4 Mar 2011 07:53:21 -0800
Message-ID: <AANLkTin4+vwuUAYBbkw89BXvH4dwH2PuUQhTuxKPYjX2_at_mail.gmail.com>
I'd would recommend AUTOALLOCATE over UNIFORM unless you require very large extents (>64MB). If require larger extents for a segment, just use the INITIAL attribute.
On Thu, Mar 3, 2011 at 10:42 AM, Mandal, Ashoke
<ashoke.k.mandal_at_medtronic.com> wrote:
> I would like find out your personal experience on using AUTOALLOACTE for
> extent management in Oracle 10g. I usually use UNIFORM extent size but
> wondering what are the drawbacks for using AUTOALLOACTE.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 04 2011 - 09:53:21 CST