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 <jkstill_at_cybcon.com> 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: ken.janusz_at_sufsys.com
> >
> > 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us
> >
> > 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com
>
> 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: ListGuru_at_fatcity.com (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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Tue Dec 18 2001 - 15:56:19 CST