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

Home -> Community -> Usenet -> c.d.o.server -> Re: Amount of Redo log generated per transaction

Re: Amount of Redo log generated per transaction

From: Orca777 <kreitsch_at_csc.com>
Date: 30 Apr 2003 14:13:54 -0700
Message-ID: <867549b5.0304301313.30a81499@posting.google.com>


ims_84_at_hotmail.com (Bilal) wrote in message news:<3bbd743.0304300701.2ae184af_at_posting.google.com>...
> hello,
>
> I wouldlike to monitor the amount of Redo Log generated per
> transaction.
> In addition I aslo want to select the redo values before the
> transaction and redo values after the transaction.
> If some one have script to perform these activities please send.
>
> Thanks
>
> Bilal

Hi,
two tips:
* use v$sesstat with the redo stats ( you will hav to join the vaues with the statnames
* try to get firm with the logminer, so you can analyze the log-content

Orca Received on Wed Apr 30 2003 - 16:13:54 CDT

Original text of this message

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