Does 11g have an autogrow function by adding a new file? Or is it still necessary to write some kind of storage for this, maybe someone has examples?

    1 answer 1

    Regular mechanism, as far as I know, no. Theoretically, you can write a script that will check the filling of table spaces using crown and add data files by template - but this is a crutch, I would not recommend using such a mechanism on production. The standard way is to use ASM (Automatic Storage Management).

    Here is the article on installation and configuration: Installing the ORACLE 11gR2 DBMS on a stand-alone server running the ORACLE OS Linux 6