Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Redo log amount
"Bilal" <ims_84_at_hotmail.com> wrote in message
news:3bbd743.0304300749.2abff191_at_posting.google.com...
> Hello
>
> I want to get information about the amount of Redolog Generated per
> transaction.
> In addition I want to get the Redo value before the Transaction and
> Redo Value after the transaction.
> If someone has scripts to achive the above results,please inform me .
A query on v$systat and v$mystat where name='redo size' ought to give you what you want.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Thu May 01 2003 - 03:02:24 CDT