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

> V$SESSTAT 'redo size'

!!! statement level statistics !!! ?

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

Regards,
Jurijs

On 2/21/06, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> 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
>
>
>

--
Jurijs
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l