Showing results for 
Search instead for 
Did you mean: 

Max db_files


Max db_files

How do I increase the max db_files parameter.
I tried editing the spfile but it is not working.
Hein van den Heuvel
Honored Contributor

Re: Max db_files

Hello Kiran,

We are talkign Oracle here right? What version? What does 'not working' mean?
sqlplus "/ as sysdba"
... sql> show parameter db_files
sql> show parameter db_files

From the Oracle Doc:

"When starting an Oracle instance, the DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and thus, the maximum number of datafiles that can be created for the instance. This limit applies for the life of the instance. You can change the value of DB_FILES (by changing the initialization parameter setting), but the new value does not take effect until you shut down and restart the instance."

The spfile is a 'newish' method to controll params like db_files on startup. This used to be initXXX.ora. Just google for spfile, or hit the Oracle online doc for furhter details on how to (not) use that file.

Some potentially useful references below.
Hari Kumar
Trusted Contributor

Re: Max db_files

Hi Kiran

Please find the enclosed attachment.

Information is Wealth ; Knowledge is Power

Re: Max db_files

I had solved the problem by creating a pfile using a spfile.
create from

I edited the pfile(init.ora)and increased the max db_files size and rebooted the database.
This solved the problem
Vince Laurent
Respected Contributor

Re: Max db_files

Awesome article! Exactly what I was looking for - thanks!
Brian Crabtree
Honored Contributor

Re: Max db_files

I believe that the following should work:

alter system set max_db_files = xxx scope=spfile;