Should Datafile Autoextend feature be turned on or off?
534454Dec 12 2011 — edited Dec 13 2011Hi Guys,
I have a questions on datafile auto extend on/off feature. I am hearing that this feature should be turned off and no one in my network seems to have a convincing answer for their claim. Is it true that it should be turned off? If yes, why? I am not seeing any evidence that it should not be turned on. Databases in question are 9i and 10g on Solaris and Linux. Any suggestions/comments are welcome.
--MM