topic Re: DB_FILES parameter in Operating System - HP-UX

DB_FILES parameter

Jeff Ohlhausen — Wed, 21 Jan 2004 10:51:55 GMT

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

Re: DB_FILES parameter

Graham Cameron_1 — Wed, 21 Jan 2004 11:05:48 GMT

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

Re: DB_FILES parameter

Stefan Farrelly — Wed, 21 Jan 2004 11:14:16 GMT

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)

Re: DB_FILES parameter

Jean-Luc Oudart — Wed, 21 Jan 2004 11:14:26 GMT

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 !

Re: DB_FILES parameter

Helen French — Wed, 21 Jan 2004 11:14:38 GMT

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