Re: SID and sessionid

Hi Zeb,

select a.username,b.spid "server process ID", b.pid "Client process ID"   FROM v$session a, v$process b
 WHERE a.paddr = b.addr
   AND a.audsid =userenv('SESSIONID');

• Kenneth Koenraadt

"zeb" <thierry.constant2_at_wanadoo.fr> wrote in message news:<3e0f0ca2$0$17152$626a54ce_at_news.free.fr>...
> The goal is to find the pid of my server process ...
Received on Sun Dec 29 2002 - 15:25:32 CST