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

Report message to a moderator

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: 10707
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

Report message to a moderator

Re: Autoextend Yes/No [message #224606 is a reply to message #224603] Wed, 14 March 2007 14:05 Go to previous message
BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic: database profiles
Next Topic: Database is expanding very fast(Space Utilization)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:10:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.