| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: From SID to connected machine
<SPAN
class=920101810-16052001>Linda,
<SPAN
class=920101810-16052001>
Have
you checked the v$session view? I believe that it shows the OS user and
machine associated with the session id.
Hope
this helps.
<SPAN
class=920101810-16052001>
<SPAN
class=920101810-16052001>Ron
<FONT face=Tahoma
size=2>-----Original Message-----From: Hagedorn, Linda
[mailto:lindah_at_epocrates.com]Sent: Tuesday, May 15, 2001 9:56
PMTo: Multiple recipients of list ORACLE-LSubject: From
SID to connected machine
Hello,
I'm looking to trace a sid from oracle to a pid on
unix to a connection/socket/port to another machine. Server is Sun
Solaris 2.8.
I'm trying to deimplement a userid and there is a
connect string to it buried somewhere on one or more of eight different
application machines. The engineers have looked for the connection, but
are unable to find it. I need to tell them which machine it's coming
from. If anyone has the steps to do this, I'd appreciate a note
back. I've tried to match the pid to the lots of logs, but cannot find a
match.
Thank you very much. Any information or
referral to documentation is appreciated.
Linda
The userid connection on topsessions:
PALMAPP SID 149 PALMAPP SID 58 PALMAPP SID
 |
 |