Re: SMON Question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 07 Sep 1999 17:48:03 GMT
Message-ID: <37e84f90.13530666@netnews.worldnet.att.net>

On Tue, 07 Sep 1999 13:38:31 +0100, Darren John Capper <darren.capper_at_preci-spark.co.uk> wrote:

> 'It (SMON) coalesces contiguous areas of free space in database
>tablespaces, where the default storage parameter, PCTINCREASE,is set to
>zero, and....'
>
>Is this true? I thought that if PCTINCREASE was zero it did exactly the
>opposite and you have to give it a value for it to coalesce space.

I'm very certain that you are correct. If PCTINCREASE is zero, no coalescing will occur unless you initiate it manually using an ALTER TABLESPACE xxx COALESCE statement.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Tue Sep 07 1999 - 12:48:03 CDT