Re: SYSTEM tablespace question

On Fri, 19 Oct 2001 15:28:59 +0200, Manuela Mueller <520040906697-0001_at_t-online.de> wrote:

>"Tyszcenko, Robert A." wrote:
>>
>> I'm a junior DBA at a new site, and the current "DBA" created a new
>> database recently. It appears that he took the default PCTINCREASE
>> for the SYSTEM tablespace, which is 50. I always thought that 0 is
>> the recommended PCTINCREASE.
>>
>> What, if any, problems are we likely to experience down the road. By
>> the way, this will be a 10+ Terabyte data warehouse.
>>
>> Thanks,
>>
>> Bob
>
>Hello Bob,
>you can't specify pctincrease for tablespace SYSTEM during a 'create
>database' statement
>(AFAIK at least not in Oracle 8.1.6, 8.1.7).
>Take a look at:
>http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem5c.htm#2061235
>
>I agree with the other posters, that any other tablespace except SYSTEM
>should have pctincrease 0
>or locally managed tablespaces with 'uniform size'.
>
>Regards
>Manuela Mueller

If you let the 8i Universal Installer on Solaris create the scripts for you, or use DBAssist, one of the first options is SYSTEM Tablespace PC increase parameter and it is quite happy to let you change this from the default of 50 PC.

It creates a shell script on Solaris called <SID>run1.sh

which contains the ALTER TABLESPACE SYSTEM command similar to

REM ********** ALTER SYSTEM TABLESPACE ********* ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 64K; and if you changed PC Increase in DBAssist it is quite happy to set the PC Increase to 0 in system.

This happens before catproc.sql etc are run.

Anyway YOU won't be putting any objects in the System Tablespace will you, so I shouldn't worry too much about it.

Chris Received on Fri Oct 19 2001 - 09:10:09 CDT