Re: SYSTEM tablespace question

From: Jon Osborne <jon.osborne_at_btinternet.com>
Date: Fri, 19 Oct 2001 13:25:47 +0100
Message-ID: <3BD01BCB.138C06FB@btinternet.com>

I believe Oracle still recommend that the SYSTEM tablespace should not have its PCTINCREASE setting changed from 50.

You're also right on the value for "normal" tablespaces being 0.

Cheers, Jon.

"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:25:47 CDT