Re: PCTFREE 1, Any advantage of using Pctfree 1

From: Kelly Young <young_at_maricopa.edu>
Date: 1997/04/15
Message-ID: <3353D9E5.5D55@maricopa.edu>#1/1

uday.v.lad_at_att.com wrote:
>
> Hi ! If you use PCTFREE = 1, SMON automatically coalsce your tablespace
> which otherwise be defragmented. Yes ! ORACLE also recommends using same.
>
> UDAY LAD
> AT&T
>
> SAM <u4immsm9_at_cpc25.usace.army.mil> wrote in article
> <3353AED6.244A_at_cpc25.usace.army.mil>...
> > Is there any advantage of setting PCTFREE 1 instead of
> > using PCTFREE 0. in oracle 7.1/7.2.3
> >
> > Is it recomended by Oracle Corp. ?
> >

I believe you are thinking of PCTINCREASE as causing SMON to coalesce a tablespace. Received on Tue Apr 15 1997 - 00:00:00 CDT