col name for a55col program for a20col username for a15select s.sid, n.name, s.value, sn.username, sn.program, sn.type, sn.modulefrom v$sesstat s join v$statname n on n.statistic# = s.statistic# join v$session sn on sn.sid = s.sidwhere name like '%redo entries%'order by value desc;
Based on above sid run below query: select username,status,state,event,sql_id,prev_sql_id from v$session where sid=1;