To identify the Largest Archivelog generators - Oracle Consulting Services | USA | 99% Customer Retention

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;