Re: SMON's coalesce & PCTINCREASE

From: quidam 17 <quidam17_at_hotmail.com>
Date: Wed, 28 Jul 1999 13:13:34 -0400
Message-ID: <379F3A3E.EB824A94@hotmail.com>

No...

SMON will coalesce tablespace only if PCTINCREASE is greater than 0...

To avoid "out of control" growing of table or index created without pctincrease parameter set, just specify "pctincrease 1" in the default storage for your tablespace...

quidam17

Alan Moorman wrote:

> It's my understanding that the STORAGE clause on tablespaces is simply to
> establish defaults for objects created in that tablespace which don't
> explicitly state STORAGE.
>
> That said, if the tablespace's STORAGE says PCTINCREASE 0, but every object
> created in the tablespace says PCTINCREASE 1, will SMON coalesce the
> tablespace?
>
> ----------
> When replying, please remove the "xyz"
Received on Wed Jul 28 1999 - 12:13:34 CDT