topic Kernal value chage Nfile value in Operating System - HP-UX

Kernal value chage Nfile value

Noble Sebastian — Mon, 14 May 2007 02:43:42 GMT

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

Re: Kernal value chage Nfile value

James R. Ferguson — Mon, 14 May 2007 05:35:18 GMT

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...

Re: Kernal value chage Nfile value

spex — Mon, 14 May 2007 08:35:15 GMT

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

Re: Kernal value chage Nfile value

Bill Hassell — Mon, 14 May 2007 21:14:54 GMT

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.

Re: Kernal value chage Nfile value

Ronald Schwartz_1 — Tue, 15 May 2007 07:55:01 GMT

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).