column program format a20
column Name-User format a20
column osuser format a20
column process format a10

select s.sid, s.serial#, s.SQL_ADDRESS, s.process , p.spid "OS Thread", b.name "Name-User",
s.osuser, s.program, s.status from v$process p, v$session s, v$bgprocess b
where p.addr = s.paddr
and p.addr = b.paddr
and s.osuser != 'SYSTEM'  UNION ALL select s.sid, s.serial#, s.SQL_ADDRESS, s.process , p.spid "OS Thread", s.username "Name-User", s.osuser, s.program, s.status from v$process p, v$session s where p.addr = s.paddr and s.osuser != 'SYSTEM'
and s.username is not null order by 1;
/