Oracle回滚段使用查询代码详解

select /*+ rule */s.sid,

    r. name rr,

     nvl(s.username, 'no transaction' ) us,

     s.osuser os,

     s.terminal te,

     t.used_urec rec,

     t.used_ublk blk

  from v$lock l, v$session s, v$rollname r,v$ transaction t

  where l.sid = s.sid(+) and

     trunc(l.id1/65536) = r.usn and

     l.type = 'TX' and

     t.ses_addr = s.saddr and

     l.lmode = 6;

select /*+ rule */s.sid,

    r. name rr,

     nvl(s.username, 'no transaction' ) us,

     s.osuser os,

     s.terminal te,

     t.used_urec rec,

     t.used_ublk blk

  from v$lock l, v$session s, v$rollname r,v$ transaction t

  where l.sid = s.sid(+) and

     trunc(l.id1/65536) = r.usn and

     l.type = 'TX' and

     t.ses_addr = s.saddr and

     l.lmode = 6;

select /*+ rule */s.sid,

    r. name rr,

     nvl(s.username, 'no transaction' ) us,

     s.osuser os,

     s.terminal te,

     t.used_urec rec,

     t.used_ublk blk

  from gv$lock l, gv$session s, v$rollname r,gv$ transaction t

  where l.sid = s.sid(+) and

     trunc(l.id1/65536) = r.usn and

     l.type = 'TX' and

     t.ses_addr = s.saddr and

     l.lmode = 6;

select /*+ rule */s.sid,

    r. name rr,

     nvl(s.username, 'no transaction' ) us,

     s.osuser os,

     s.terminal te,

     t.used_urec rec,

     t.used_ublk blk

  from v$lock l, v$session s, v$rollname r,v$ transaction t

  where l.sid = s.sid(+) and

     trunc(l.id1/65536) = r.usn and

     l.type = 'TX' and

     t.ses_addr = s.saddr and

     l.lmode = 6;