topic Re: Max db_files in Operating System - HP-UX

Max db_files

Kiran_27 — Sat, 21 Aug 2004 06:43:37 GMT

How do I increase the max db_files parameter.
I tried editing the spfile but it is not working.

Re: Max db_files

Hein van den Heuvel — Sat, 21 Aug 2004 12:44:13 GMT

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

Re: Max db_files

Hari Kumar — Sat, 21 Aug 2004 13:22:35 GMT

Hi Kiran

Please find the enclosed attachment.

Hari

Re: Max db_files

Kiran_27 — Sun, 22 Aug 2004 05:51:22 GMT

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

Re: Max db_files

Vince Laurent — Wed, 02 Nov 2005 10:30:27 GMT

Awesome article! Exactly what I was looking for - thanks!

Re: Max db_files

Brian Crabtree — Wed, 02 Nov 2005 20:32:45 GMT

I believe that the following should work:

alter system set max_db_files = xxx scope=spfile;

Brian