RE: Finding open database links database wide

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 14 Feb 2005 14:00:42 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410511E788@usahm236.amer.corp.eds.com>

Queries to show all distributed sessions from an instance, to an instance, and combined were posted at the cooperative FAQ a couple years ago. If you work in a distributed environment these can be handy.

How do I find distributed queries / transactions (either issued from or connecting to this instance)?
http://www.jlcomp.demon.co.uk/faq/find_dist.html

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick Sent: Monday, February 14, 2005 1:20 PM
To: scott.hutchinson_at_interact-analysis.com; oracle-l_at_freelists.org Cc: Bruce.Reardon_at_comalco.riotinto.com.au Subject: RE: Finding open database links database wide

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
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 14 2005 - 14:03:55 CST