Is there a way to see how much of your resource limits you've used

[Victor Semaska_3]

Greetings,

We're having a problem on one of our Tru64 servers running Oracle 9i(ES45 w/ 12GBs memory, V5.1B PK5). Our DBA thinks we're running out of one of the resources that's listed in the 'ulimit -a' command.

ulimit shows you what your resource limits are. Is there some utility that shows how much of those resource you're actually using.

Thanks,
Vic

[Victor Semaska_3]

Here's an update:

The DBA now thinks that the problem may be the limit on the no. of open files. In ulimit -a I believe it's the line:

nofiles(descriptors) 4096

The system parameters that control this I think is, according to sysconfig -Q proc:

open_max_soft - type=INT op=CQ min_val=0 max_val=4096
open_max_hard - type=INT op=CQ min_val=0 max_val=4096

It looks like the absolute max value is 4096. Is this true or can you raise the maximum with another system parameter?

Thanks,
Vic

[Mark Poeschl_2 · Accepted solution]

The man page for sys_attrs_proc shows 65536 as the maximum for open_max_hard. The limit can only be changed to above 4096 programatically using the setsysinfo() call.

[Victor Semaska_3]

Thanks.