Kernal value chage Nfile value

[Noble Sebastian]

my hp ux HP-UX scpdb B.11.23 U ia64 1316749136 unlimited-user license
my server is given error
file: table is full

i think maximum file opening more than Nfile value

my nfile current value 75536

i plan to inreases nfile value
for changeing nfile
how to calulate new nfile value ..?


thanks
noble

[James R. Ferguson]

Hi:

Disregard any formula and simply set the value you need. The default is 64K for systems with more than 1GB of memory. Be generous with your setting. Very little memory is consumed by the kernel for each increment.

Regards!

...JRF...

[spex]

Hello Noble,

If the machine is intended to be an Oracle RDBMS server, you should follow Oracle's recommended kernel parameter settings.

Here they are the recommended settings for Oracle 9i:
http://download-east.oracle.com/docs/html/A96167_01/pre.htm#CHDCJDHI

With respect to nfile, the recommended value is '(15 * NPROC + 2048)'. Note that the recommended setting for nproc, to which nfile refers in its formula, is '4096'.

PCS

[Bill Hassell]

The new value (NOT a formula) is easy to calculate: 75536 * 2 = 151072. This should be adequate for quite a while. Do not increase nfile by a small amount as this will require many, many reboots. There is no practical limit for nfile.

[Ronald Schwartz_1]

Go ahead and double the value of nfile, don't use the formula just put 151072. Then you can check the usage with sar -v 5 12 during your heavy usage to see what your apps are using (the file-sz column).