http://www.ixora.com.au/tips/creation/bsq.htm
suggests that a non-zero pctincrease may be viable, with the reasoning being based on deferred rollback segments. Rumour has it, Oracle 9i.2 will have a lmt system tablespace which will make the argument moot. hth connor --- Jared Still <[EMAIL PROTECTED]> wrote: > > 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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).