GET PID for SID

SELECT P.SPID, S.SID, S.SERIAL# FROM V$PROCESS P, V$SESSION S WHERE P.ADDR = S.PADDR AND S.SID = 405; col “SID/SERIAL” format a10 col username format a15 col osuser format a15 col program format a40 select     s.sid || ‘,’ || s.serial# “SID/SERIAL” ,     s.username ,     s.osuser ,     p.spid “OS PID” ,     s.program from     v$session s ,     v$process…