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: Why pctincrease set to 1 for SYSTEM tablespace ?

Re: Why pctincrease set to 1 for SYSTEM tablespace ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Dec 1999 19:59:26 GMT
Message-ID: <386a67f9.1190229@news.demon.nl>


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

Original text of this message

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