Maximum number of datafiles for an Oracle database

The maximum number of datafiles an Oracle database can have is controlled by the parameter , 'db_files'. You can find the maximum number of datafiles for a database as shown below.

SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------------------- ----------- ------------------------------
db_files.                             integer     200
SQL>

You can change or increase the value of this using ALTER SYSTEM command.

Published with Blogger-droid v1.6.9