Re: Q: OK to reset PCTINCREASE on the SYSTEM tablespace?

If the tablespace(s) in question is Dictionary Managed, and you set the default PCTFREE=0 for that tablespace, then SMON will no longer coallesce free space. This may cause problems with future extent allocations, or it may not. It all depends.

If the tablespace is Locally Managed, then don't worry about PCTINCREASE for these tablespaces as Oracle is ignoring it anyway.

HTH,
Brian

Jeremy Henty wrote:
>
> I have some legacy databases where PCTINCREASE = 50 on some
> tablespaces, including SYSTEM. Is there any risk in resetting
> it to 0? I have done so successfully with other tablespaces,
> but I am nervy about touching SYSTEM. Are there any pitfalls?
>
> Thanks in advance,
>
> Jeremy Henty

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"