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