Get ospid from sid

From Oramosswiki

SET LINESIZE 132
UNDEFINE sid
COLUMN username heading "Username" format a20
COLUMN username heading "Username" format a20
COLUMN status heading "Status" format a20
COLUMN sid heading "SID" format 999999
COLUMN serial# heading "Serial#" format 999999
COLUMN spid heading "OS PID" format 999999
COLUMN osuser heading "OS USer" format a20
COLUMN program heading "Program" format a30
SELECT a.username
,      a.status
,      a.sid
,      a.serial#
,      b.spid
,      a.osuser
,      b.program
FROM   v$session a
,      v$process b
WHERE  a.paddr=b.addr(+)
AND    a.sid = &sid
/

Which gives results like:

SQL>  @get_ospid_from_sid
Enter value for sid: 135
old  11: AND    a.sid = &sid
new  11: AND    a.sid = 135 

Username             Status                   SID Serial# OS PID       OS USer              Program
-------------------- -------------------- ------- ------- ------------ -------------------- --------
JEFF               ACTIVE                   135   24202 282834       jeff               oracle@myserver-0 (P001)

1 row selected.