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

What I meant was that instead of using V$SESSTAT 'db block changes' as your starting point, you should use V$SESSSTAT 'redo size' if you are interested in
Redo generation.

At 08:39 PM Tuesday, Jurijs Velikanovs wrote:
> > 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

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

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