Laura wrote:
> 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......)
Go to Morgan's Library at www.psoug.org
Scroll down to SYS_CONTEXT.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed May 30 2007 - 10:29:36 CDT
