Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

DB_FILES parameter

SOLVED
Go to solution
Jeff Ohlhausen
Frequent Advisor

DB_FILES parameter

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
Do or do not - there is no try.
4 REPLIES
Graham Cameron_1
Honored Contributor
Solution

Re: DB_FILES parameter

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Stefan Farrelly
Honored Contributor

Re: DB_FILES parameter

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)
Im from Palmerston North, New Zealand, but somehow ended up in London...
Jean-Luc Oudart
Honored Contributor

Re: DB_FILES parameter

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 !
fiat lux
Helen French
Honored Contributor

Re: DB_FILES parameter

I think the limit is 1024. But I 've also saw in some documents that the limit is 1022.
Life is a promise, fulfill it!