Process Explorer shows you information about which handles and DLLs processes have opened or loaded. It is a freeware process viewing application that's light on system resources, portable, advanced and powerful.
Here are some screenshots to illustrate the features and user interface of this application: