identify which session is using more UNDO in oracle database

 

set lines 200 pages 200

select s.sid, t.name, s.value

from v$sesstat s, v$statname t

where s.statistic#=t.statistic#

and t.name='undo change vector size'

order by s.value desc;