To identify the Largest Archivelog generators

select
s.sid, username,t.used_ublk,t.used_urec from v$transaction t,v$session s where

t.addr=s.taddr
order by 3;