RE: Finding open database links database wide
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Feb 2005 13:25:42 -0500
Well, blow me down there it is in the K2GTITID_ORA column??!!=20
-----Original Message-----
From: scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx
[mailto:scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx]=20
Sent: Monday, February 14, 2005 3:26 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxx>:
> 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@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
>=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
> --
> //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.
> --
> //www.freelists.org/webpage/oracle-l
>=20
::This message sent using the free Web Mail service from
http://TheName.co.uk
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
