the way to know which transaction is using a large number of undo space

select used_ublk from v$transaction order by used_ublk desc;