see_rollback.sql

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;