process.sql

set pagesize 200
set linesize 100
select substr(a.username,1,20) "ORACLE USERNAME",
	a.sid, a.status, b.username "UNIX USERNAME", b.spid, a.lockwait,
substr(b.program,17,4) "PROC"
from v$session a, v$process b
where a.paddr  = b.addr and
	a.username <> ' '
order by a.sid
/