RE: unix - calc file descriptors

Interesting, I just did a similar process last Friday (in prep for a go-live)...

I used lsof to see all the open files for all Oracle processes on the DB server. I then compared this with a sar -v output. I found that in my situation it was easy to get a rough guess of the required number of open file descriptor
(nfile Unix param) by simply multiply (number_of_datafiles x number_of_dedicated_server_process). It's a rough enough guess but works...Not sure if you wanted/needed something much more exact than that...

Thanks!
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sean Hull Sent: Monday, July 11, 2005 11:13 AM
To: oracle-l_at_freelists.org
Subject: unix - calc file descriptors

I'm wondering how to calculate the number of file descriptors Oracle will
use on Unix. Obviously there will be one file descriptor for each file,

and for each socket (connection through listener). How about for IPC connections? How about for Oracle processes (oracle executable file)? I'm assuming device files aren't counted, as the OS or root user has those
mounted & open.

Perhaps someone could point me to a document, or metalink reference which
details this.

Thx.
Sean

--

Sean Hull, Senior Consultant

Heavyweight Internet Group		Rockefeller Center, Box 5352
http://iheavy.com			New York, NY 10185
voice: 646.827.9877x23			fax: 646.827.3434

Subscribe to our monthly newsletter - HIG Best Practices http://www.iheavy.com/lists/?p=subscribe&id=1

Sean is author of "Oracle and Open Source" http://www.oreilly.com/catalog/oracleopen/
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 11 2005 - 13:29:15 CDT