Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SMON and coalescing
It will be done by SMON if the tablespace pctincrease is not zero. If it
is zero you will have to ALTER TABLESPACE <tablespace name> COALESCE.
John Vernes <vernes.j_at_consunet.nl> wrote in article
<6ja0pj$3s3$1_at_news.worldonline.nl>...
> 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 Tue May 12 1998 - 13:42:50 CDT