Re: Why pctincrease set to 1 for SYSTEM tablespace ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 30 Dec 1999 18:14:21 +0800
Message-ID: <386B307D.3A3A@yahoo.com>

Sybrand Bakker wrote:
>
> 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

I have to admit I'm not a great fan of this...A little tweaking of sql.bsq gets you very close to consistently sized extents in SYSTEM which then obviates the need for SMON 'cleansing'

Happy New Year
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 30 1999 - 04:14:21 CST