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
vivekmenon_k@yahoo.co.uk
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

Report message to a moderator

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: 10707
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
Quote:
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.

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/dfiles.htm#7337
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96536/ch145.htm#1016261

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:28:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.