Add new comment

select s.sid,n.name,s.value
  from  v$sesstat s,v$statname n
  where n.name = 'redo blocks written'
           and s.statistic#=n.statistic#
  order by value;