Who is generating excessive redo in Oracle

Who is generating excessive redo  in Oracle


      SELECT s.sid, s.serial#, s.username, s.program,
      t.used_ublk, t.used_urec
      FROM v$session s, v$transaction t
      WHERE s.taddr = t.addr
      ORDER BY 5 desc, 6 desc, 1, 2, 3, 4;


Prompt My session redo....

select a.name, b.value
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and a.name = 'redo size';

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post