Originally posted by ramji_1123
Hi,

What is DB_FILES, MAXDATAFILES ?

Where these parameters can be seen ?
When you run CREATE DATABASE, you often have a parameter called MAXDATAFILES. The value that is entered for this parameter or some default value is stored in the CONTROL FILE upon DB creation. This is the so called "hard" limit on the number of datafiles which can be associated with this particular database. Remember DB, not instance!

In the init.ora you have DB_FILES. This is the limit on the total number of files associated with a particular INSTANCE of a database. As you know several instances can be associated with a single DB. This is called the "soft limit".