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
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
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
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
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
15 matches
Mail list logo