Re: Long Delay before rolling back

I figured out what you are talking about. I will try it again, the next time something is happening:

select s.username, rn.name,rs.curext
,rs.curblk, t.used_ublk, t.used_urec
,case when bitand(t.flag,power(2,7)) > 0 then 'RB in Progres­s'   else 'Not Rolling ­Back'
  end as "F Status"

from    v$transaction   t


       ,v$session       s

       ,v$rollname      rn

       ,v$rollstat      rs

where  t.addr     = s.taddr
and    t.xidusn   = rn.usn
and    rn.usn     = rs.usn