Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center