Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CHANGES/UNDO/REDO statement level statistics Is there any chance to get those?

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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 21 Feb 2006 21:10:16 +0800
Message-Id: <6.2.1.2.0.20060221210924.01fb9610@pop.singnet.com.sg>

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
Received on Tue Feb 21 2006 - 07:10:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US