Re: map SQLNET connects to process ids on UNIX

Kevin,

Link the addr field in v$process to the paddr field of v$session. If you are not MTS, then this will give you the pid of the client (v$session.process) and the pid of the server process (v$process.spid) .

Hope this helps,

SCott

Kevin Brand wrote:

> How can I determine which process ( oracleSID ) is associated with a particular
> user that is coming in over SQLNET? The PROCESS field does not indicate the
> correct pid, or the correct format for a pid.
>
> Thanks,
>
> -Kevin
> --
>
> remove the x for an email reply
Received on Tue Jul 07 1998 - 17:00:03 CDT