Re: SYSTEM tablespace question

From: Stephen T. Parfitt <steve.parfitt_at_sympatico.ca>
Date: Fri, 19 Oct 2001 08:57:36 -0400
Message-ID: <3BD02340.D85946E@sympatico.ca>

My way of thinking about using a value of 50 for PCTINCREASE on the SYSTEM tablespace vs. 0 for PCTINCREASE on normal tablespaces, is this: ... when the SYSTEM tablespace has to extend, it's quite likely that the complexity and scale of the database as a whole has changed. It's less likely that the SYSTEM tablespace only needs to extend incrementally.
... when a normal tablespace needs to extend, it's simply because there is more data; the complexity of the database has not changed.

Stephen Parfitt

"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
Received on Fri Oct 19 2001 - 07:57:36 CDT