Maximum Oracle DB_FILES on SAP R/3 4.7

[Former Member]

Dear Gurus,

Currently, we have set DB_FILES parameter to 768. We need to set this number to higher one (may be around 1024).

Our environment right now is

OS : AIX 5.3 TL9

DB : Oracle 9i

ulimit setting on OS :

1. ulimit -a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) 32768

coredump(blocks) unlimited

nofiles(descriptors) 2000

If I want to set DB_FILES to 1024, is it possible ??

Thank you.

Best regards,

Ardhian

http://inaroka.co.cc

[stefan_koehler · Accepted solution]

Hello Ardhian,

> If I want to set DB_FILES to 1024, is it possible ??

Sure, but keep in mind that the parameter DB_FILES is just a "soft limit". The hard limit is set by creating the database with the MAXDATAFILES clause. In newer oracle releases (i guess from Oracle 9i upward) the hard limit is also "removed" by expanding the corresponding section in the control files.

http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_55a.htm#SQLRF01204

MAXDATAFILES Clause
Specify the initial sizing of the datafiles section of the control file at CREATE DATABASE or CREATE CONTROLFILE time. An attempt to add a file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, causes the Oracle Database control file to expand automatically so that the datafiles section can accommodate more files.
The number of datafiles accessible to your instance is also limited by the initialization parameter DB_FILES.

Regards

Stefan

[Former Member · Accepted solution]

@stefan :

I see. I already saw my control file and it show me 784 for MAXDATAFILES.

I think I need higher value than 784 so I need to re-create my control file.

Thank you for your info.

ardhian