How Do You Control Number Of Datafiles One Can Have In An Oracle Database?


1 Answers

Anonymous Profile
Anonymous answered
When starting an Oracle instance, the database's parameter file indicates the amount of SGA space to reserve for datafile information; the maximum number of datafiles is controlled by the DB_FILES parameter. This limit applies only for the life of the instance.

- Abdul Jabbar Karpoor

Answer Question