CHANGES/UNDO/REDO statement level statistics … Is there any chance to get those?

Hello Everyone,

Some times there is need to troubleshoot systems/modules with huge amount of REDO generated. The main goal in a troubleshooting process is to spot out the statement generating the most of REDO. Then it can be passed to a development and job is done ;)

I wonder if any one has suggestion for the better way to troubleshoot this type of issues.

My thoughts so far:
- Can easily spot the session which generating the most of the changes
(V$SESSTAT db block changes).
- Can find the object (V$SEGMENT_STATISTICS db block changes)

• Can try to find any DML which referencing the object (the session have as an opened cursor). But it is still just guessing.

What do you think?
Can you share your thoughts on that subject, please?

Thank you in advance,
Jurijs

--
http://www.freelists.org/webpage/oracle-l