Re: Change PCTINCREAE for SYSTEM Tablespace

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).