I should have said Oracle 8.1.7.4 under Windows 2000. What does lsof do - perhaps I can find an equivalent under Windows? Thanks, Bruce -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeremiah Wilton Sent: Friday, 11 February 2005 5:54 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Finding open database links database wide On Fri, 11 Feb 2005, Reardon, Bruce (CALBBAY) wrote: > How can I find which sessions have open database links? It is not elegant, but I use lsof on Unix. Good luck figuring out which session opened it if you are in Shared Server mode. -- Jeremiah Wilton ORA-600 Consulting Emergencies - Seminars - Hiring http://www.ora-600.net -- //www.freelists.org/webpage/oracle-l NOTICE This e-mail and any attachments are private and confidential and may = contain privileged information. If you are not an authorised recipient, = the copying or distribution of this e-mail and any attachments is = prohibited and you must not read, print or act in reliance on this = e-mail or attachments. This notice should not be removed. -- //www.freelists.org/webpage/oracle-l