Re: Datafile sizes

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: zhuchao@xxxxxxxxx
  • Date: Thu, 3 May 2007 20:07:34 -0500


Excellent points. As you point out, you must keep increasing db_files, and
rebooting for that to take effect (I haven't checked 10g). But when you
created the database, you set a MAXDATAFILES value. DB_FILES can't exceed
MAXDATAFILES. If you still have the script used to create the database, you
can find your MAXDATAFILES value. Otherwise you can alter database backup
controlfile to trace, then find it in the trace file. To increase
MAXDATAFILES, you must rebuild the control file, a somewhat nerve-wracking
operation for a production database.

Dennis Williams

Other related posts: