Excessive Redologs in 11gR2
Recently Database is generating lots of redo logs. I am not aware of any changes. How do I trace what is causing the excessive redo?
I think there might be some sqls that are causing too much redo logs I guess
11gR2 RAC database, linux 6.7
I found this query useful
SELECT s.sid, s.serial#, s.username, s.program,i.block_changes, s.sql_idFROM v$session s, v$sess_io i, v$sqltext tWHERE s.sid = i.sidAND s.sql_id = t.sql_idORDER BY 5 desc, 1, 2, 3, 4;
Thanks