CHANGES/UNDO/REDO statement level statistics … Is there any chance to get those?
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 21 Feb 2006 12:16:04 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
