QUERY TO CHECK THE PID FROM THE SID

select sid,serial#,inst_id from gv$session;
select PID, p.PROGRAM
from gv$process p, gv$session s
where s.paddr=p.addr
and sid=<SID above>;