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

V$SESSTAT 'redo size'

At 08:16 PM Tuesday, Jurijs Velikanovs wrote:
>Hello Everyone,
>
>Some times there is need to troubleshoot systems/modules with huge
>amount of REDO generated.
>
>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.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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