that it is necessary.
Kip Bryant
|FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM
|tablespace.
|(In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe
on
|dev and sandbox databases).
|If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM
ORACLE-L
Sam -
I haven't made the system tablespace autoextend because I can't easily
recover the space if it overextends. I would rather take the risk that
something hits an error from a lack of space in the system tablespace. With
other tablespaces you can always rebuild the tablespace if you
FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM
tablespace.
(In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe on
dev and sandbox databases).
If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM
rollback) or temporary segments
I use AUTOEXTEND and it has been extremely helpful to me in managing growth.
However, my policy is not to use autoextend for SYSTEM, rollback tablespace,
or temp tablespace.
SYSTEM (for me) is relatively stable. The only time I have significant growth
in SYSTEM is during an upgrade
Title: RE: System Tablespace and Autoextend
I have read complaints about SYS.IDL% objects having PCTINCREASE 50 and
space problems when they extend, in the forums. I went to check and
mine are already set to 0 along with 2147483645 MAXEXTENTS. I created
a TAR and verified with Oracle
Sam -
I haven't made the system tablespace autoextend because I can't easily
recover the space if it overextends. I would rather take the risk that
something hits an error from a lack of space in the system tablespace. With
other tablespaces you can always rebuild the tablespace if you need
:
[EMAIL PROTECTED] Subject: System Tablespace and Autoextend
om
in metalink for documents on this, but turned up nothing. Does
anybody have experience on the dangers of allowing the SYSTEM tablespace
to
autoextend and also any documents on Metalink or OTN that describe this
problem?
We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our
Oracle
.
-Original Message-
Sent: Thursday, October 24, 2002 4:46 PM
To: Multiple recipients of list ORACLE-L
Sam -
I haven't made the system tablespace autoextend because I can't easily
recover the space if it overextends. I would rather take the risk that
something hits an error from a lack
, so I have no
experience on what actually does happen.
I looked in metalink for documents on this, but turned up nothing. Does
anybody have experience on the dangers of allowing the SYSTEM tablespace to
autoextend and also any documents on Metalink or OTN that describe this
problem?
We
10 matches
Mail list logo