select spid 
from v$process a, v$session b
where b.sid = &SID
and   b.paddr = a.addr;
