The Oracle8i Admin Guide, Chapter 19, General Management of Schema Objects:
Give guidelines for setting storage parameters for data dictionary tables. Setting PCINCREASE to 50 is an artifact from Oracle 6 and early releases of 7 which had a rather limited number of extents. Jared On Tuesday 18 December 2001 05:30, Mercadante, Thomas F wrote: > Kimberly, > > I would agree with you if an experienced DBA makes the decision to change > the storage parameters, and they absolutely know what the benfits would be. > > Generally speaking though, I think changing anything in the SYSTEM > tablespace is bad practice. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Monday, December 17, 2001 8:45 PM > To: Multiple recipients of list ORACLE-L > > > Actually, I would not ignore the storage parameters of the SYSTEM > tablespace. > There are legit reasons to change the pctincrease to 0. If you leave it at > 50 then SMON (or PMON can't remember at the moment) will try to coalesce > the tablespace every time it wakes up. Its work it has to do that it > really does > not need to do. Better off scheduling to happen at your time schedule. > > -----Original Message----- > Thomas F > Sent: Monday, December 17, 2001 7:45 AM > To: Multiple recipients of list ORACLE-L > > > Ken, > > Do yourself a favor. Ignore the SYSTEM tablespace storage params. The > ONLY thing you should concern yourself in regard with the SYSTEM tablespace > is if the file needs to extend itself because it is too full. All other > storage parameters are created by Oracle at database create time and should > not be changed. > > For other tablespaces, you can change this parameter anytime after the > tablespace has been created. It will not, however, change existing > extents, but will be used when new extents are allocated. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Monday, December 17, 2001 10:16 AM > To: Multiple recipients of list ORACLE-L > > > Is there any way that I can change the PCTINCREASE for the SYSTEM > tablespace without recreating the DB? For some reason the person who > created the DB I am working on set PCTINCREASE to 50 (or didn't did not > include this parameter). I am using this DB for a data conversion so > there is no software connected to it and in turn no users on it. > > Thanks, > Ken Janusz, CPIM > Database Conversion Lead > Sufficient Systems, Inc. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
