Maxdata files and db_files parameter
Oracle RDBMS 11.2.0.4
HP-UX Itanium B.11.31
Per Oracle note 119507.1 Maxdatafiles and DB_FILES parameter,
"This article is applicable from Oracle7 through 11.2. The difference is that, with Oracle 8 and above when MAXDATAFILES is reached the controlfile will expand automatically as long as there is disk space available."
Reading the above quote, to me implies that as long as the controlfile has space, and there is space for datafiles I don't need to worry about the value of maxdatafiles, is this correct?
The note goes on to suggest review of the 11.2 Database Administrator Guide Appendix F which shows that maxdatafiles is 65534. Should my DB reach that number I might have a problem.