Re: How should we find out the total redo amount for a transaction?

From: Yong Huang <yong321_at_yahoo.com>
Date: 27 Aug 2004 09:37:34 -0700
Message-ID: <b3cb12d6.0408270837.5d7bd36a@posting.google.com>

juma_gandhi_at_yahoo.com (Jumma) wrote in message news:<c9ade84.0408270015.619249d1_at_posting.google.com>...
>
> So the bottom line is that how can we find out the total redo amount
> of a huge transaction(s).

Can't you simply look at the 'redo size' statistic in v$sesstat before and after the transaction? Find the statistic# in v$statname (or v$sysstat) and use it in v$sesstat. There're some other redo-related stats you may be interested in, such as redo entries.

Yong Huang Received on Fri Aug 27 2004 - 11:37:34 CDT