December 2002
Intermediate to advanced
928 pages
85h 29m
English
DB_FILES
Value: specified in the MAXDATAFILES clause the last time CREATE DATABASE or CREATE CONTROLFILE was executed, or the current actual number of datafiles in the data
Default: operating system dependent
Specifies the maximum number of database files that can be opened for this database. This parameter should be set for the maximum number of files, subject to operating system constraints, that will ever be specified for the database, including files to be added via the ADD DATAFILE statement. If the value of DB_FILES is increased, all instances accessing the database must be shut down and restarted before the new value can take effect.