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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sean Hull Sent: Monday, July 11, 2005 11:13 AM To: oracle-l@xxxxxxxxxxxxx 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/ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l