set linesize 120
select p.pid, p.spid "SPID (OS PID)", s.sid, s.serial#, s.osuser, s.program , s.status
from v$process p, v$session s 
where s.paddr=p.addr