the default of 50 for pctincrease, like the (before 8.1.6) default
block size for database creation of 2k is legacy.
It harkens back to the "olden days" when you couldn't have lots of
extents or autoextend.
I'd be much more likely to change the maxextents parameter on the
SYSTEM tables or to put autoextend on the datafiles in the SYSTEM
tablespace.
- Kimberly Smith <ksmith2_at_myfirstlink.net> wrote:
> I think even Oracle would disagree with you on that one. While it
> is unsupported to change anything in the sql.bsq script (except with
> Trusted Oracle where its required to actually get it to create a
> database)
> anything that
> is changeable after the fact is fair game. As a matter of fact,
> for all those GUI freaks out there;-) its one of the things you
> actually
> get to change when creating the SYSTEM tablespace using dbassist.
> Oracle had to pick a default so they chose 50. They also chose a
> default for the SGA but up until now it was pretty much a useless
> default. No where do they say that 50 for pctincrease is recommended
> or that it should stay that way. Don't forget, this is not
> SQL Server. We are encouraged by Oracle to set the system up
> for optimal performance.
>
> -----Original Message-----
> Thomas F
> Sent: Tuesday, December 18, 2001 5:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: Kimberly Smith
> INET: ksmith2_at_myfirstlink.net
>
> 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: Kimberly Smith
> INET: ksmith2_at_myfirstlink.net
>
> 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).
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
Received on Tue Dec 18 2001 - 12:54:34 CST
