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 20:37:30 +0800
Message-Id: <6.2.1.2.0.20060221203703.01fab500@pop.singnet.com.sg>

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
Received on Tue Feb 21 2006 - 06:37:30 CST

Original text of this message

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