Re: Help! What's my PID & SID

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: Sun, 11 Oct 1998 13:20:51 +0800
Message-ID: <6vpni9$3h3$2@news.seed.net.tw>

Joe R Jurgena ¼¶¼g©ó¤å³¹ <6vlu1u$t9f$1_at_clarknet.clark.net>...
>I am using Oracle 7.3.3 on a Sun running Solaris. How can I determine
>what my PID is with a sql query? I want to use my pid to find my SID
>in the v$session table.
>Thanks
>Joe

select s.sid, p.sid
  from v$session s, v$process p
  where s.audsid=userenv('sessionid')
    and s.paddr=p.addr;

That's your SID and PID.
Hope this help. Received on Sun Oct 11 1998 - 00:20:51 CDT