topic Re: File table is full in Operating System - HP-UX

File table is full

Rushank — Tue, 14 May 2002 20:05:32 GMT

I'm getting this error in my syslog file.

Env : Oracle 8i. N-Classe HP_UX 11, 8G Phy Mem.

MAXUSERS=600
nfile=20000 ( (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))

What is recomended number here to solve this problem

Re: File table is full

MANOJ SRIVASTAVA — Tue, 14 May 2002 20:08:40 GMT

Rushank

Change it to atleast 50000 and monitor using sar -v 2 10 , the same was the issue wiht one of our production boxes and i have seen even 50000 getting full actually is is realtive to the application being used , but I recommned chaging to 50000 and then monitoring it.

Manoj Srivastava

Re: File table is full

James R. Ferguson — Tue, 14 May 2002 20:12:15 GMT

Hi:

What's recommended is what works. You can increase 'maxusers' or 'nproc' (which is based on 'maxusers' anyway), or you can simply substitute an appropriate value for 'nfile' that meets your needs.

The formulae are generally designed to keep balance among kernel parameters and thereby optimize kernel structures. They do not always work for all environments.

Remember that you can track 'nfile' with 'sar -v'. The current, high-water mark and number of overflows will be recorded:

# sar -v 10 20

...would take 20-samples 10-seconds apart, for instance.

Regards!

...JRF...

Re: File table is full

S.K. Chan — Tue, 14 May 2002 20:14:05 GMT

We got an L-class (4GB RAM) running the same thing with MAXUSERS=1000.
There is not definite answer to your question. It depends on how much the system table space is being used at the time it hit the limit. If I were you, I would double maxusers for a start.

Re: File table is full

Rushank — Tue, 14 May 2002 20:25:56 GMT

Out put of sar -v 10 20

16:23:48 text-sz ov proc-sz ov inod-sz ov file-sz ov
16:23:58 N/A N/A 526/4000 0 4457/5672 0 15925/20010 0
16:24:08 N/A N/A 527/4000 0 4128/5672 0 15894/20010 0
16:24:18 N/A N/A 528/4000 0 3913/5672 0 15900/20010 0
16:24:28 N/A N/A 527/4000 0 3673/5672 0 15911/20010 0
16:24:38 N/A N/A 529/4000 0 3462/5672 0 15922/20010 0
16:24:48 N/A N/A 529/4000 0 3242/5672 0 15926/20010 0
16:24:58 N/A N/A 528/4000 0 3006/5672 0 15900/20010 0
16:25:08 N/A N/A 533/4000 0 3011/5672 0 15896/20010 0
16:25:18 N/A N/A 532/4000 0 3002/5672 0 15854/20010 0
16:25:28 N/A N/A 527/4000 0 3010/5672 0 15846/20010 0
16:25:38 N/A N/A 527/4000 0 3007/5672 0 15815/20010 0
16:25:48 N/A N/A 525/4000 0 2986/5672 0 15812/20010 0
16:25:58 N/A N/A 527/4000 0 2974/5672 0 15809/20010 0
16:26:08 N/A N/A 527/4000 0 2980/5672 0 15820/20010 0
16:26:18 N/A N/A 527/4000 0 2975/5672 0 15835/20010 0
16:26:28 N/A N/A 528/4000 0 2959/5672 0 15842/20010 0
16:26:38 N/A N/A 528/4000 0 3006/5672 0 15812/20010 0
16:26:48 N/A N/A 531/4000 0 3008/5672 0 15856/20010 0
16:26:58 N/A N/A 534/4000 0 2986/5672 0 15862/20010 0
16:27:08 N/A N/A 527/4000 0 2982/5672 0 15852/20010 0

Re: File table is full

S.K. Chan — Tue, 14 May 2002 20:48:18 GMT

First line from your data ..
proc-sz 526/4000 gives 13% utilization of nproc
inod-sz 4457/5672 gives 78% utilization of ninode
file-sz 15925/20010 gives 79% utlization of nfile.

So no changes is needed for nproc. You might want to bump up ninode and nfile so that it works out to about 50% utilization. To get 50%..
ninode will be about 9000
nfile will be about 32000