Home » RDBMS Server » Server Administration » Need for db_files
Need for db_files [message #216272] Fri, 26 January 2007 00:04 Go to next message
Messages: 6
Registered: October 2006
Location: India
Junior Member
what is the use and purpose of setting db_files parameter when there is already an limit to number of datafiles that can be created which has been specified using MAXDATAFILES clause in controlfile
Re: Need for db_files [message #216281 is a reply to message #216272] Fri, 26 January 2007 02:00 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
DB_FILES is initsid.ora parameter that is bound to the instance and hence is editable. MAXDATFILES is bound to controlfile (when you create the database) and not editable (unless you recreate the controlfile).
Quoting doc
However, if you attempt to add a new file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, the control file will expand automatically so that the datafiles section can accommodate more files.

Previous Topic: opatch error code = 130 ???
Next Topic: Max extents reached for LOB Segments
Goto Forum:

Current Time: Sat Jul 22 07:46:57 CDT 2017

Total time taken to generate the page: 0.11234 seconds