Re: Why pctincrease set to 1 for SYSTEM tablespace ?

From: spencer <spencerp_at_swbell.net>
Date: Thu, 30 Dec 1999 00:42:18 -0600
Message-ID: <K9Da4.462$_j1.8894@nnrp3.rcsntx.swbell.net>

In short...

for the TABLESPACE, specify
DEFAULT STORAGE ( ... PCTINCREASE 1 ... ) for TABLES, override the tablespace default, and specify STORAGE ( ... PCTINCREASE 0 ... ) if PCTINCREASE is set to 0 in the DEFAULT STORAGE clause for the tablespace, then free space will become fragmented... and
that means another set of tasks for an already overworked DBA...

i say leave it set to 1 and let SMON manage the freespace

"Matthieu Jobert" <mjobert_at_freesurf.fr> wrote in message news:946491895.203584_at_pepette...
> In the script generated by Oracle 8.1.5 NT database creation
assistant,
> there is
> REM ********** ALTER SYSTEM TABLESPACE *********
> ALTER TABLESPACE SYSTEM
> DEFAULT STORAGE ( INITIAL 100K NEXT 100K MINEXTENTS 1
MAXEXTENTS 300
> PCTINCREASE 1);
>
> Why is PCTINCREASE set to 1 and not to 0 ???
>
Received on Thu Dec 30 1999 - 00:42:18 CST