Re: Why is NEXT_EXTENT changing all the time?

From: <mike_st0ne_at_my-deja.com>
Date: Thu, 25 Jan 2001 16:03:21 GMT
Message-ID: <94pio2$isp$1@nnrp1.deja.com>

In article <3A6FBBA2.4F17BAF2_at_exesolutions.com>, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:

> I can not imagine why it is happening unless you have pctincrease set
to a
> non-zero value.. But I can not imagine why you would want the EXTENT
sizes to be
> the same. That is pretty much the definition of a bad design.
>
> Reasonable people will disagree on this but for myself, initial
extents should
> be sized to hold, as near as possible, 1 to 3 years worth of data
depending on
> the application. Next extents are generally sized, again depending
upon
> anticipated table growth, at between 25% and 100% of initial extent
size. And
> please please set PCTINCREASE to ZERO for all tables and indexes.
>
> Daniel A. Morgan
>
>

Presumably you're not a fan of locally managed tablespaces with "uniform size" extent management then. Bad design on Oracle's part? ;-)

Mike S
in your "CREATE TABLESPACE"

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 10:03:21 CST