RE: Auto Extend On, Increment By

From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
To: <Joel.Patterson@xxxxxxxxxxx>, <Smith.Steven@xxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
Date: Fri, 16 Mar 2007 09:10:13 -0700

No reason not to set autoextend on temp and undo - just make sure you
have a reasonable maxsize along with it - as you should have with ALL
autoextend tablespaces.

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Joel.Patterson@xxxxxxxxxxx



I agree.   I was also thinking that UNDO would be analogous to TEMP.

  
________________________________


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Steven K -
MSHA


 

I don't see the big downside of having autoextend on (except for temp
tablespaces - those things can become a monster with a bad piece of
code).


Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

References:

RE: Auto Extend On, Increment By
From: Smith, Steven K - MSHA

RE: Auto Extend On, Increment By
From: Joel.Patterson

RE: Auto Extend On, Increment By

Other related posts: