From Mac OS X Server FAQ
GUI
From the Activity Monitor application, double click on a process name. A window will open showing some general process information and three tabs: Memory, Statistics and Open Files. Select the Open Files tab for a list of files the process has open.