select * 
from ( select a.username,a.sid,b.value 
       from v$session a,v$sesstat b,v$statname c 
       where a.sid=b.sid 
         and b.statistic#=c.statistic# 
         and c.name='redo size' 
       order by b.value desc ) 
where rownum < 11;