Re: Why pctincrease set to 1 for SYSTEM tablespace ?

From: Paul <paulj_at_newsfeeds.com>
Date: 30 Dec 1999 01:53:23 -0500
Message-ID: <m3k8lwor6k.fsf@newsfeeds.com>

"Matthieu Jobert" <mjobert_at_freesurf.fr> writes:

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

This is because Oracle will automatically coalesce tablespaces with a default PCTINCREASE of non-zero.

It is the SMON process that periodically does this coalescing, although I don't know how often this occurs or how to control the frequency.

Regards
Paul

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Dec 30 1999 - 00:53:23 CST