I've turned on the autoextend function for the datafiles in my database through the OEM. Do I need to restart the database for the change to take effect? I know this qustions is simplistic but please excuse a newbie.
Printable View
I've turned on the autoextend function for the datafiles in my database through the OEM. Do I need to restart the database for the change to take effect? I know this qustions is simplistic but please excuse a newbie.
No, it is not necessary to shut down the DB. Oracle rulez!
Just take care that :
* You have enought space in your hard disk / filesystem to support the NEXT EXTENT parameter of your segments (tables, indexes, etc). If you are using Local managed tablespaces you should have enought space to support the increment of the datafiles according Oracle's formula.
Regards.
If you are goin to use AUTOEXTEND, use a MAXSIZE on your datafiles as well.
Thanks for the help.