Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SMON and Coalesce of Free Extents
In article <3896f660.2512817921_at_news.interpath.net>,
ghubert_at_skillspoint.com (Gene Hubert) wrote:
> In the days of Oracle 7.x I remember that auto-coalesce of free
> extents only happened if the pctincrease for a tablespace was
> non-zero. Does anyone know if this is still true? All I could find
> in the 8.0.5 docs was the following:
>
> ---
> By default, SMON (system monitor) processes incrementally
> coalesce the free extents of tablespaces in the background. If
> desired, you can disable SMON coalescing.
> ---
>
> I've always created tablespaces with pctincrease of 1 to enable
> coalescing but am wondering if this makes any difference now.
>
I believe it is still true; however, you can manually coalesce using
the alter tablespace x coalesce command which will work even with a
pctincrease of zero on the tablespace.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Feb 01 2000 - 14:55:57 CST
![]() |
![]() |