RE: Finding open database links database wide

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jeremiah Wilton Sent: Friday, 11 February 2005 5:54 PM
To: oracle-l_at_freelists.org
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
--
http://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.
--
http://www.freelists.org/webpage/oracle-l