1748033 Members
5116 Online
108757 Solutions
New Discussion юеВ

Re: Max db_files

 
Kiran_27
Advisor

Max db_files

How do I increase the max db_files parameter.
I tried editing the spfile but it is not working.
5 REPLIES 5
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
change
shutdown
startup
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.
Cheers,
Hein.


http://www.oracle.com/pls/db92/db92.print_hit_summary?search_string=spfile

http://www.oracle.com/technology/documentation/oracle9i.html

http://www.oracledba.co.uk/tips/9i_spfile.htm


http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2200190221847

http://www.praetoriate.com/oracle_tips_spfile.htm
Hari Kumar
Trusted Contributor

Re: Max db_files

Hi Kiran

Please find the enclosed attachment.

Hari
Information is Wealth ; Knowledge is Power
Kiran_27
Advisor

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;

Brian