Re: SMON and coalescing

From: Peter Lewis <peter.lewis_at_bgs.ac.uk>
Date: Mon, 18 May 1998 15:20:33 +0100
Message-ID: <356043B0.CF54D46B@bgs.ac.uk>

If PCTINCREASE is set to 0, then SMON will not automatically coalesce adjoining extents. Setting PCTINCREASE to 1 will allow SMON to coalesce the adjoining extents, but may have knock-on effects if the SMON process is very busy, as well as the obvious change to your storage parameters. If you are using version 7.3 or higher you can use ALTER TABLESPACE ts_name COALESCE (during times of low demand).

Hope this is of help,

Peter Lewis

John Vernes wrote:

> Hello,
>
> I have a short question regarding coalescing of tablespaces.
>
> As I understand this should be done by the System Monitor (SMON) process.
> Since the SMON comes by every couple of minutes and the coalescing doesn't
> happen is there something I am overlooking??
>
> Greetings
>
> John
Received on Mon May 18 1998 - 09:20:33 CDT