maxfiles_lim > 2048 sensible setting?

[Ralph Grothe]

Database procs ran obvoiusly into trouble reaching the boundary of simultaniously open files.
Now I'm tempted not only to increase the soft limit (i.e. maxfiles) to 1024, but also to raise the hard limit (i.e. maxfiles_lim).
Does this make sense to you experienced sysadmins for a database server that also has to serve many HTTP requests?
I have absolutely no idea of plausible values.

[Christopher McCray_1]

On all of my servers the maxfiles and maxfiles_lim is 2048 or more. You can't go wrong if you set them to 2048.

Good luck
Chris

[Ralph Grothe]

Hi Christopher,

I don't want to run into trouble again.
My settings currently are:

# grep maxfile /stand/system
maxfiles 120
maxfiles_lim 2048

but these were to low.
So I want to set maxfiles_lim beyond 2048

[Sanjay_6]

Hi Ralph,

If you want you can apply the HP-UX tuned kernel parameter set for OLTP Database server system. This tunes most of the parameters required for oracle ... database purposes. It will set the maxfiles limit to 2048 by default.

To do this, do

sam --> Kernel Configuration --> Configurable kernel Parameters --> Selct Action from the top bar ---> Apply tuned parameter set --> Select OLTP System / Database Server System.

Rebuild Kernel and reboot. Hopefully you may not be required to tune the kernel parameters again until and unless an application specifically demands it.

Hope this helps.

thanks

[Ralph Grothe]

Hi Sanjay,

my set of kernel params derives from this mentioned parameter set.

[Christopher McCray_1 · Accepted solution]

Your maxfiles_lim is actually fine; it is your maxfiles is what needs upping. You can set it the same value as you _lim if you want.

BTW - What type of server do you have? It may/may not have something to do with it???

Good luck
Chris

[Sanjay_6]

Hi Ralph,

Just checked my system kernel parameters.

maxfiles =2048
maxfiles_lim = 2048

though you can increase the parameter to the value you want, but you should not have to.

We have Oracle parallel server and MC / SG running on these systems.

Hope this helps.

thanks

[Christopher McCray_1]

Also, you can look at this link,

http://us.support.external.hp.com/cki/bin/doc.pl/sid=4e6f0b0803272d4b25/screen=ckiDisplayDocument?docId=200000039545441

Maybe it will help

[Christopher McCray_1]

I just skimmed this doc, but from what I thought I saw, you need to build the kernel manually if you want these parms > 2048. See below:

http://us-support.external.hp.com/cki/bin/doc.pl/sid=d0b7866b05f648439f/screen=ckiDisplayDocument?docId=200000055459688

[Satish Y]

Hi Ralph,

U should not and I think u cannot increase maxfiles_lim greater than 2048

Actual limits are min=30,max=2048 for both maxfiles and maxfiles_lim(u can see with sysdef cmd). But plausible values for the system not running any SQL server is 60 & 1024 and for the system running SQL server is 1024 & 2048.

Cheers...
Satish.