Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: OK to reset PCTINCREASE on the SYSTEM tablespace?

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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 05 Feb 2004 08:11:49 -0800
Message-ID: <1075997455.120192@yasure>


Jeremy Henty wrote:

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

>
>
> Details: Oracle version 8.1.7 .
>
> Jeremy Henty

If the SYSTEM tablespace ignore it. If anywhere else ... change it to zero.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Feb 05 2004 - 10:11:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US