set pagesize 1000
set echo on
column rbs format a6
column oracle_user format a12 heading "Oracle|Username"
column sid format 99999 heading "Oracle|SID"
column SERIAL# format 99999 heading "Oracle|Serial#"
column unix_pid format a6 heading "Unix|PID"
column Client_User format a12 heading "Client|Username"
column Unix_user format a12 heading "Unix|Username"

select R.name rbs, nvl(S.username, 'None') oracle_user,
S.osuser client_user, P.username unix_user, S.sid sid,
S.serial# serial#, P.spid unix_pid
from v$process P, v$rollname R, v$session S, v$transaction T
where S.taddr=T.addr
        and S.paddr = P.addr(+)
        and R.usn=T.xidusn(+)
        order by R.name
/