Re: session_id & PID

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 2 Sep 1999 09:29:17 +0200
Message-ID: <7ql91q$d7m$1@oceanite.cybercable.fr>

For example, to get the Oracle sid and Unix pid of your current session you can use:

select s.sid /* Oracle SID */,
       s.serial# /* Oracle serial number */,
       s.username /* Oracle username */,
       p.spid /* OS pid */,
       p.username /* OS username */,

from v$process p, v$session s
where s.paddr = p.addr
  and s.audsid = userenv('SESSIONID')
/

Tenot Christophe a écrit dans le message <7qjttc$cae$1_at_mars.worldonline.fr>...
>Dear all,
>
>I'm trying to have the correspondance between the oracle SID and a UNIX
>PID....
>Is there anybody have any idea how to do?
>
>many thanks...
>
>best regards
>
>Christophe
>
>
Received on Thu Sep 02 1999 - 02:29:17 CDT