Home » RDBMS Server » Server Administration » Autoextend Yes/No
Autoextend Yes/No [message #224603] Wed, 14 March 2007 13:53 Go to next message
Martyn.Jones
Messages: 3
Registered: March 2007
Junior Member
Does anyone have any opinions on the Autoextend option for datafiles?

I heard mix reports about this feature. Should I switch it on and let Oracle manage the data file extending, or should I switch it off and manually manage the data files?

Martyn
Re: Autoextend Yes/No [message #224605 is a reply to message #224603] Wed, 14 March 2007 14:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search before posting.
Just another healthy discussion
http://www.orafaq.com/forum/m/182620/42800/?srch=call+unix#msg_182588
Re: Autoextend Yes/No [message #224606 is a reply to message #224603] Wed, 14 March 2007 14:05 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Should I switch it on and let Oracle manage the data file extending, or should I switch it off and manually manage the data files?
It depends upon your application, system & what you are comfortable with.
Both have their pros & cons.
No single answer fits all DBs environments. I use both where I deem each to be appropriate.
Previous Topic: database profiles
Next Topic: Database is expanding very fast(Space Utilization)
Goto Forum:
  


Current Time: Fri Dec 09 21:27:49 CST 2016

Total time taken to generate the page: 0.11973 seconds