maxfiles

[nancy rippey]

I need to increase the # of maxfiles due to the following message.
WARNING:Oracle instance running on a system with low open file descriptor.
Is there a way for me to tell how close I am to the current maxfiles setting.

Thanks in advance

[Pete Randall]

Do you have Glance? If so, the system tables report will show you.


Pete

[nancy rippey]

Yes. I tried that but didn't get what I was looking for. Maybe I didn't look deep enough. I'll pull it back up.

[James R. Ferguson]

Hi Nancy:

You might use 'lsof' to tally the number of open files by a process.

Regards!

...JRF...

[Pete Randall]

In the GUI, it's "Reports" > "System Info" > "System Tables Report". The second line shows "File Table (nfile)".


Pete

[Pete Randall]

However, if you truly mean maxfiles, the per-process limit, Glance won't tell you. I don't know of a way to see maxfiles.


Pete

[nancy rippey]

nfile is only at %53. I need the maxfiles which I thougth was the number of open files per a process. I tried lsof earlier but did not get what I needed. Is there an lsof command to give me the # of open files against a certain process?

[James R. Ferguson]

Hi (again) Nancy:

> Is there an lsof command to give me the # of open files against a certain process?

As I hinted in my first post (for example):

# lsof -p 27267

[nancy rippey]

I'm just using lsof and adding up the number of occurrences for each process. Thanks.