DB_FILES parameter

[Jeff Ohlhausen]

Hi,
I'm sure this will be an easy 10 points for some of you. What's the limit for HP-UX and Oracle for this parameter?

Thanks
Jeff

[Graham Cameron_1 · Accepted solution]

Quoted from Metalink:

The default is 200, the lower limit is the current actual number of datafiles in the database, and the upper limit is whatever you specified in the MAXDATAFILES clause the last time CREATE DATABASE or CREATE CONTROLFILE was executed.

You may now ask what is the upper limit for MAXDATAFILES. For Unix and Oracle 8 it was 65536 per db, for oracle 9/10 it is likely to be the same or higher. Note that within this there is a restriction of 1022 files per tablespace.

-- Graham

[Stefan Farrelly]

DB_FILES maxium value on HP-UX is the kernel parameter defining the max number of open files per process; maxfiles_lim

You can see this setting on HP-UX by doing;
kmtune|grep maxfiles_lim

The default for maxfiles_lim (and thus DB_FILES) is 1024, and the maximum value under HP-UX is 60000

So DB_FILES max = 60000 (as long as maxfiles_lim is set to 60000)

[Jean-Luc Oudart]

OS dependant
MAXDATAFILES

Table 1-4 Create Control File Parameters
Parameter Default Value Maximum Value
MAXDATAFILES
30
65534

MAXINSTANCES
1
63

MAXLOGFILES
16
255

MAXLOGHISTORY
100
65534

MAXLOGMEMBERS
2

Sorry for the formatting

Rgds
Jean-Luc

PS : never been near the limit !

[Helen French]

I think the limit is 1024. But I 've also saw in some documents that the limit is 1022.