If you do decide to use the MAXLOGFILES,
MAXLOGMEMBERS, and similar clauses of the CREATE DATABASE command, be sure to carefully read the manuals so that you understand exactly what these clauses do, and how they relate to the database initialization parameters.
Take MAXLOGFILES, for example. The temptation will be to set it to match the number of log files specified in the CREATE DATABASE command. This parameter actually relates to the number of log file groups, not individual files. Further, it is constrained at the lower end by the value of the log_files initialization parameter. This varies by release and operating system. On Windows NT, using Oracle 8.1.5, the default log_files value is
255, and consequently the lower limit for MAXLOGFILES would also be 255. To go lower, you would need to modify the log_files parameter and restart the instance.
There's nothing inherently wrong with using these clauses. It's just that sometimes there's more going on than meets the eye.
To create a new database, you need to start a new Oracle instance and execute a CREATE DATABASE command. This command will create the control files, the system tablespace file (or files), and one rollback segment in the system tablespace. Because CREATE DATABASE is a somewhat long command, it's best to write it ahead of time, and store it in a text file. Move your mouse over the following image to learn about the
syntax of the command.
The various clauses, such as MAXLOGFILES, MAXDATAFILES, and so forth, don't need to be written in the order shown above. You can write them in
any order that you like. Most of the clauses are optional. They all have defaults, and unless I have specific reasons to change a particular
default, I usually leave the clause out of the command. For this course, you should do the same. Two clauses that I always include, however, are the LOGFILE and DATAFILE clauses. I always include these so that I can explicitely name the files, specify their sizes, and place them where I want. Sizing is important.
You, as the DBA, should always exert control over the size of your database files.