Database Administration (MOSC)

MOSC Banner

Excessive Redologs in 11gR2

edited Oct 7, 2019 3:30PM in Database Administration (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center