1747983 Members
4690 Online
108756 Solutions
New Discussion юеВ

File table is full

 
Rushank
Super Advisor

File table is full

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
5 REPLIES 5
MANOJ SRIVASTAVA
Honored Contributor

Re: File table is full

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
James R. Ferguson
Acclaimed Contributor

Re: File table is full

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...
S.K. Chan
Honored Contributor

Re: File table is full

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.
Rushank
Super Advisor

Re: File table is full

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

S.K. Chan
Honored Contributor

Re: File table is full

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