Users in rollback segments : V_Rollname « System Tables Views « Oracle PL / SQL






Users in rollback segments

    


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>

   
    
    
    
  








Related examples in the same category

1.Query V$ROLLNAME, V$ROLLSTAT