Re: Why pctincrease set to 1 for SYSTEM tablespace ?

On Wed, 29 Dec 1999 19:28:46 +0100, "Matthieu Jobert" <mjobert_at_freesurf.fr> wrote:

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

Because this will allow SMON to coalesce the SYSTEM tablespace periodically.

Hth,

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Dec 29 1999 - 13:59:26 CST