Re: should initial = next?

From: <yong321_at_yahoo.com>
Date: Tue, 06 Feb 2001 22:02:47 GMT
Message-ID: <95ps9v$uno$1@nnrp1.deja.com>

I always use the same initial and next extent size. But one DBA here set up his tablespace with a much smaller initial size than next size (pctincrease 0). The reason is that his tables are a lot of times empty and he has more than 300 (I think) tables. It makes some sense.

Yong Huang
yong321_at_yahoo.com

In article <3a7fbcec_at_news.iprimus.com.au>, "Howard J. Rogers" <howardjr_at_www.com> wrote:
> Not only should initial equal next, but ALL segments within the one
> tablespace should have the same extent sizes.

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 16:02:47 CST