RE: RE: Change PCTINCREAE for SYSTEM Tablespace
Title: RE: RE: Change PCTINCREAE for SYSTEM Tablespace Hi Tom, Can you review my views in changing pctincrease value: If i'm creating database manualy without dbassistant, The steps are, 1) CONNECT INTERNAL 2) CREATE DATABASE ( LOGFILES, A SINGLE DATAFILE FOR SYSTEM TABLESPACE AND other infos) 3) CREATING SYSTEM TABLESPACE 4) OTHER STEPS. GOING ON... Now why not i can change the PCTINCREASE at the step3?... In what way it'd affect the DB? And why we need to change sql.bsq instead? Hope that i didn't say anything incorrect. Let me know ur valuable reply... Nirmal., -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 03 ÔæÇá, 1422 04:50 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Change PCTINCREAE for SYSTEM Tablespace Tom, I agree and disagree with you, respectfully. Oracle does allow some changes to be made to sql.bsq and they always leave the option open to make changes after database creation and I don't see this request as all that odd. But for the most part if you do as recommended and leave the system tablespace to sys only you should not have a problem. That is until migration time!! Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 12/18/2001 5:30 AM 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: Kimberly Smith 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
RE: Change PCTINCREAE for SYSTEM Tablespace
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: Kimberly Smith 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).
RE: Change PCTINCREAE for SYSTEM Tablespace
I agree, I am leaving the SYSTEM tablespace alone. Hands off. Ken -Original Message- Sent: Tuesday, December 18, 2001 7:30 AM To: Multiple recipients of list ORACLE-L Subject:RE: Change PCTINCREAE for SYSTEM Tablespace 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: Kimberly Smith 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: Ken Janusz INET
RE: Change PCTINCREAE for SYSTEM Tablespace
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: [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: Kimberly Smith 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:
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: [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).
RE: Change PCTINCREAE for SYSTEM Tablespace
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 [EMAIL PROTECTED] 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: [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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: Change PCTINCREAE for SYSTEM Tablespace
I have to agree with Kimberly. Knowing your storage parameters is the way to go. Don't just settle for defaults. Bing -Original Message- Sent: Tuesday, December 18, 2001 7:10 AM To: Multiple recipients of list ORACLE-L 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: [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: Kimberly Smith 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
Re: Change PCTINCREAE for SYSTEM Tablespace
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
Re: Change PCTINCREAE for SYSTEM Tablespace
Ken, AFAIK 50 is default PCTINCREASE for SYSTEM. I believe there are no reasons to change it for SYSTEM. What's your goal? Do you want to decrease total size of the tablespace by setting PCTINCREASE a bit less? Regards, Ed Oracle8,8i Certified DBA and Zivanologist 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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).
RE: Change PCTINCREAE for SYSTEM Tablespace
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).
Re: Change PCTINCREAE for SYSTEM Tablespace
Hi Ken, If no one has told you yet, all you have to do is to use the alter tablespace command, for example: alter tablespace system default storage (pctincrease 0); select tablespace_name, pct_increase from dba_tablespaces where tablespace_name='SYSTEM'; You shouldn't need to rebuild your database, (e.g. your control files) to reset this tablespace storage parameter. Hope this resolves your problem for you there. Dan Whatley Sr. Oracle DBA Motorola, Inc. Global Information Systems 7700 W. Parmer Ln. Austin, Tx 78729 Ken Janusz wrote: 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: Dan Whatley 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).
Re: Change PCTINCREAE for SYSTEM Tablespace
Ken, The system tablespace is created in the file sql.bsq, which should be found in %ORACLE_HOME%\rdbms\admin. Create tablespace system is the first statement in the file. However, before you touch that file, you MUST read Steve's article at http://www.ixora.com.au/tips/creation/bsq.htm. Two points he makes: 1 - Don't edit sql.bsq, make a copy and edit and use the copy, 2- leave the defaults alone, and set a minimum extent of 64k on the system ts. Really, read the page before you do it. HTH, Yosi Ken Janusz wrote: 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: Yosi Greenfield 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).
RE: Change PCTINCREAE for SYSTEM Tablespace
I left the SYSTEM tablespace alone. I did change the PCTINCREASE parameter to 0 in all the tables in the applications. Ken -Original Message- Sent: Monday, December 17, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject:RE: Change PCTINCREAE for SYSTEM Tablespace Ken: You can change the default PCTINCREASE for new objects in the SYSTEM Tablespace, or you can change the PCTINCREASE for each object. When the database is created the PCTINCREASE is set to 50% so that the database would have sufficient room to allocate objects. There is no other way, that will allow you to keep your Oracle support in tact, to change this value. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, December 17, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Subject:Change PCTINCREAE for SYSTEM Tablespace 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: Karniotis, Stephen 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: 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).
RE: Change PCTINCREAE for SYSTEM Tablespace
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: Kimberly Smith 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).
RE: Change PCTINCREAE for SYSTEM Tablespace
Can't stress enough how important those manuals are. OK, lets see, you are talking about a tablespace You want to modify that tablespace... Hum, I might go look at the alter tablespace command Course I could just tell you what you want to know but I really think you will learn more by looking it up. -Original Message- Sent: Monday, December 17, 2001 7: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: Kimberly Smith 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).
