Get os pid from sid - Oracle Database Script. SET lines 123 col USERNAME FOR a15 col OSUSER FOR a8 col MACHINE FOR a15 col PROGRAM FOR a20 SELECT b.spid, a.username, a.program, a.osuser, a.machine, a.sid, a.serial#, a.status FROM gv$session a, gv$process b WHERE addr=paddr(+) AND sid=&sid;
SET lines 123 col USERNAME FOR a15 col OSUSER FOR a8 col MACHINE FOR a15 col PROGRAM FOR a20 SELECT b.spid, a.username, a.program, a.osuser, a.machine, a.sid, a.serial#, a.status FROM gv$session a, gv$process b WHERE addr=paddr(+) AND sid=&sid;