Users in rollback segments : V_SESSION « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. V_SESSION

SQL> REM
SQL> column rr heading 'RB Segment' format a18
SQL> column us heading 'Username' format a15
SQL> column os heading 'OS User' format a10
SQL> column te heading 'Terminal' format a10
SQL> select R.Name rr,
  2         nvl(S.Username,'no transaction') us,
  3         S.Osuser os,
  4         S.Terminal te
  5    from V$LOCK L, V$SESSION S, V$ROLLNAME R
  6   where L.Sid = S.Sid(+)
  7     and trunc(L.Id1/65536) = R.USN
  8     and L.Type = 'TX'
  9     and L.Lmode = 6
 10  order by R.Name
 11  /
SQL>