Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Finding open database links database wide

Re: Finding open database links database wide

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Thu, 10 Feb 2005 22:54:02 -0800 (PST)
Message-ID: <Pine.LNX.4.60.0502102252090.2761@cpq7598>


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
Received on Fri Feb 11 2005 - 01:56:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US