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

Hemant,

Thank you for your response. Yes you are right, but most of the cases changes corresponds to UNDO and redo generation. The problem is that Oracle doesn't include this statistics in v$sql% type of views.
Therefore it is quite difficult to spot the statement which generates the most of CHANGES/UNDO/REDO.

Steave Adams just rightly sported one (not direct way) to spot that kind of SQL-s.
With right level of statistics you can query v$sql_plan_statistics.cu_buffer_gets to get some impression of most expensive SQL-s in that context.

Jurijs

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

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