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

Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieve remote host from a Stored procedure

Re: Retrieve remote host from a Stored procedure

From: Laura <f.marchioni_at_pride.it>
Date: 30 May 2007 07:41:42 -0700
Message-ID: <1180536102.853721.186760@q75g2000hsh.googlegroups.com>


On 30 Mag, 16:07, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On May 30, 9:54 am, Laura <f.marchi..._at_pride.it> wrote:
>
> > Hi all,
> > is it possible to retrieve from a Stored Procedure the remote
> > host name or address who owns the Session ?
> > Thanks
> > Laura
>
> What do you mean by "address who owns the Session?"
>
> Do you want the SID and other information related to the remote
> session in a distributed transaction?
>
> See the following article and repost with a more specific question.
>
> 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
>
> The following thread may also be of interest:http://groups.google.com/group/comp.databases.oracle.server/browse_fr...
>
> HTH -- Mark D Powell --

I have checked your link....it seems that the view v$session is needed, but I don't have
access to that view....(most likely because I'm logged to oracle as javauser and not as SYS......) Received on Wed May 30 2007 - 09:41:42 CDT

Original text of this message

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