 | |
Retrieve remote host from a Stored procedure
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Retrieve remote host from a Stored procedure -
05-30-2007
, 08:54 AM
#2
| |||
| |||
|
|
Hi all, is it possible to retrieve from a Stored Procedure the remote host name or address who owns the Session ? Thanks Laura |
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....cc7d59 a3abac
HTH -- Mark D Powell --
#3
| |||
| |||
|
|
On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/browse_fr... HTH -- Mark D Powell -- |
Well I'm calling the Stored Procedure from a Java Servlet with Jdbc.
So I neet to know the remote address(or host) of the Servlet (that
launched the Stored Procedure).
Is it possible to do it ?
Thanks
Laura
#4
| |||
| |||
|
|
On 30 Mag, 16:07, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote: On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/browse_fr... HTH -- Mark D Powell -- Hello, thanks for your reply. Well I'm calling the Stored Procedure from a Java Servlet with Jdbc. So I neet to know the remote address(or host) of the Servlet (that launched the Stored Procedure). Is it possible to do it ? Thanks Laura- Hide quoted text - - Show quoted text - |
or from a different one?
#5
| |||
| |||
|
|
On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/browse_fr... HTH -- Mark D Powell -- |
needed, but I don't have
access to that view....(most likely because I'm logged to oracle as
javauser and not as SYS......)
#6
| |||
| |||
|
|
On May 30, 10:33 am, Laura <f.marchi... (AT) pride (DOT) it> wrote: On 30 Mag, 16:07, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote: On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/browse_fr... HTH -- Mark D Powell -- Hello, thanks for your reply. Well I'm calling the Stored Procedure from a Java Servlet with Jdbc. So I neet to know the remote address(or host) of the Servlet (that launched the Stored Procedure). Is it possible to do it ? Thanks Laura- Hide quoted text - - Show quoted text - Do you need to retrieve that information in the same database session or from a different one?- Nascondi testo tra virgolette - - Mostra testo tra virgolette - |
the stored procedure)
#7
| |||
| |||
|
|
On 30 Mag, 16:07, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote: On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/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......)- Hide quoted text - - Show quoted text - |
and you won't need access to v$session.
--
Sybrand Bakker
Senior Oracle DBA
#8
| |||
| |||
|
|
On 30 Mag, 16:07, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote: On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/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......) |
Scroll down to SYS_CONTEXT.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#9
| |||
| |||
|
|
On May 30, 4:41 pm, Laura <f.marchi... (AT) pride (DOT) it> wrote: On 30 Mag, 16:07, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote: On May 30, 9:54 am, Laura <f.marchi... (AT) pride (DOT) 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....rver/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......)- Hide quoted text - - Show quoted text - Please look up the SYS_CONTEXT function in your SQL reference manual, and you won't need access to v$session. -- Sybrand Bakker Senior Oracle DBA- Nascondi testo tra virgolette - - Mostra testo tra virgolette - |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.