Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SMON and Coalesce of Free Extents

Re: SMON and Coalesce of Free Extents

From: <markp7832_at_my-deja.com>
Date: Tue, 01 Feb 2000 20:55:57 GMT
Message-ID: <877h8o$2eo$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US