Title: RE: From SID to connected machine
I can get all the session info, but the machine name isn't externalized. By elimination I've found the problem machine is va8. Since I have the processes in place and they're not hurting anything, I have time to research.
Here
Title: RE: From SID to connected machine
Thanks for the idea. It's not telling me the machine, though...
SID USERNAME OSUSER PROCESS MACHINE TERMINAL
-- -- -- - --- --
58 PA
Linda,
You have to look at v$process which give the pid. This is the OS process
number. You can link it to v$session to get the username.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 9:55 PM
> Hello,
>
> I'm l
Try this statement out:
select sid,
username,
osuser,
process,
machine,
terminal,
from v$session
where username = 'PALMAPP;
HTH
Mark
-Original Message-
Sent: Wednesday, May 16, 2001 02:56
To: Multiple recipients of list ORACLE-L
Hello,
I'm looking
Title: From SID to connected machine
Linda,
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.
Ron
-Original Message-From: Hagedorn, Linda
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 15
Title: 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 mor