problem with nfile while opening a DataBase

[remer]

hi,

we have a problem in opening an Oracle 10g 10.2.0.2 Database.
Upon starting the nfile increased from 900 to 65K or the total nfile of the system.

is there a problem with our server parameters or the database parameters?

OS is HP-UX 11.23.
nfile=65536

thanks in advance.

[TTr · Accepted solution]

That's a lot of files! Although it is possible for an oracle database to popen that many files, it is probably unlikely. How big is that database environment?

[Rita C Workman]

Are you saying nfile increased or that some process caused a huge raise in the number of open files.
Oracle 10 itself would not require 65536 files to be opened. Some process with lousy code might though.

HPUX 11.23 default setting for nfile might be 65536, which you check by doing kmtune -q nfile.
You may need to monitor your settings and reduce accordingly. You could run sar -v 1 10 and look at what the file-sz output is. That's a reflection of nfile .

Rgrds,
Rita

My guess it's your parm that simply needs reduced.