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: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 30 Apr 2003 22:08:40 GMT
Message-ID: <3eb048c7.1339901376@nyc.news.speakeasy.net>


This info can be found in statspack reports (average redo per xaction)

You can also look at v$mystat before and after the transaction

On 30 Apr 2003 08:01:06 -0700, ims_84_at_hotmail.com (Bilal) wrote:

>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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Apr 30 2003 - 17:08:40 CDT

Original text of this message

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