SCRIPT:To check user information including OS Process_id

col username for a20
col osuser for a20
col program for a40
select a.sid ,a.serial# "SID/SERIAL",
a.username ,a.osuser, p.spid "OS PID",a.program
from v$session a, v$process p
where
a.paddr = p.addr
order by to_number(p.spid)