RE: Finding open database links database wide

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 14 Feb 2005 13:19:43 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA65022DFC66@25exch1.vicorpower.vicr.com>

Well, that's one heck of a neat trick, except it does not tell you which user has which link open. Is there a way to catch that??=20

-----Original Message-----
From: scott.hutchinson_at_interact-analysis.com [mailto:scott.hutchinson_at_interact-analysis.com]=20 Sent: Monday, February 14, 2005 3:26 AM
To: oracle-l_at_freelists.org
Cc: Bruce.Reardon_at_comalco.riotinto.com.au Subject: RE: Finding open database links database wide

I'm not sure about Oracle8, but in Oracle9 I use this (must run as sys):

select
username,osuser,status,sid,serial#,machine,process,terminal,program=20 from v$session=20
where saddr in ( select k2gtdses from sys.x$k2gte );=20

Scott.

Quoting "Reardon, Bruce (CALBBAY)"
<Bruce.Reardon_at_comalco.riotinto.com.au>:

> 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

>=20

> -----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

>=20
>=20

> On Fri, 11 Feb 2005, Reardon, Bruce (CALBBAY) wrote:

>=20

> > How can I find which sessions have open database links?

>=20

> 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.

>=20

> --
> Jeremiah Wilton
> ORA-600 Consulting
> Emergencies - Seminars - Hiring
> http://www.ora-600.net
> --
> http://www.freelists.org/webpage/oracle-l

>=20
>=20

> NOTICE
> This e-mail and any attachments are private and confidential and may =
=3D
> contain privileged information. If you are not an authorised
recipient, =3D
> the copying or distribution of this e-mail and any attachments is =3D
> prohibited and you must not read, print or act in reliance on this =3D
> e-mail or attachments.
> This notice should not be removed.
> --
> http://www.freelists.org/webpage/oracle-l
>=20

::This message sent using the free Web Mail service from http://TheName.co.uk

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 14 2005 - 13:22:43 CST