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 /