DB FILES... think??? determine???

When starting Oracle database instance, DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and maximum number of datafiles that can be created for the instance.
Anyway we can change... (but we have to shutdown/startup)

So, if value of DB_FILES is too low, we cannot add datafiles beyond the DB_FILES limit, so we have to shutdown+startup database for changing DB_FILES value.
if value of DB_FILES is too high, memory is unnecessarily consumed.

We have to shutdown all nodes and startup them.Because, we may find Error: ORA 1174Text: DB_FILES is aaa but needs to be bbbto be compatible

Just think and determine about number of datafile... if don't want to maintenance to change it.

By the way, Determine DB_FILES initialization parameter... so don't need to interest MAXDATAFILES parameter specifies on control file.

If we attempt to add a new file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, the control file will expand automatically so that the datafiles section can accommodate more files.

Disclaimer: Blog contents express the viewpoints of their independent authors and
are not reviewed for correctness or accuracy by
Toolbox for IT. Any opinions, comments, solutions or other commentary
expressed by blog authors are not endorsed or recommended by
Toolbox for IT
or any vendor. If you feel a blog entry is inappropriate,
click here to notify
Toolbox for IT.