Find Sessions Generating Lots of Redo or Archive logs
1. Login to a user with dba privilege
2. Execute the query
sql> SELECT s.sid, s.serial#, s.username, s.program, i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 asc, 1, 2, 3, 4;
3. Run the query multiple times and examine the delta between each occurrence of BLOCK_CHANGES. Large deltas indicate high redo generation by the session.
Hope this helps. Regards Rupam
