RE: Finding open database links database wide

  • From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Feb 2005 08:43:32 +1100

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

Other related posts: