Re: Why pctincrease set to 1 for SYSTEM tablespace ?

From: Brent Tucker <btucker_at_servman.com>
Date: Wed, 29 Dec 1999 14:13:32 -0700
Message-ID: <s6q9cs4c5k234@corp.supernews.com>

The only thing that readily comes to mind is that this would allow system to be coallesced.

However, Oracle should be sizing the objects correctly so that space could be reused. And, since the data modification rate for tables in system will typically be low, fragmentation shouldn't really be a problem.

Brent

Matthieu Jobert wrote in message <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 Wed Dec 29 1999 - 15:13:32 CST