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
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
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
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
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
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
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
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.
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
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
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
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
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
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
: 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
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
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
17 matches
Mail list logo