How to find SPID using SID in oracle database

 

Use below query to find the SPID associated with a particular SID.

col sid format 999999
col username format a20
col osuser format a15

select a.sid, a.serial#,a.username, a.osuser, b.spid
from v$session a, v$process b
where a.paddr= b.addr
and a.sid='&sid'
order by a.sid;

Note: Pass the SID for which we want to find the SPID.

Thanks for going through the post..............