Re: AUTOALLOACATE vs. UNIFORM extent size in Oracle10g

From: Greg Rahn <>
Date: Fri, 4 Mar 2011 07:53:21 -0800
Message-ID: <>

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

Greg Rahn
Received on Fri Mar 04 2011 - 09:53:21 CST

Original text of this message