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: PCTFREE 1, Any advantage of using Pctfree 1

Re: PCTFREE 1, Any advantage of using Pctfree 1

From: <uday.v.lad_at_att.com>
Date: 1997/04/15
Message-ID: <01bc49d0$2f6c8e80$48362c87@sap06.bsi.att.com>#1/1 







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. ?

> 

Received on Tue Apr 15 1997 - 00:00:00 CDT












Original text of this message













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