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

On 27 Aug 2004 01:15:51 -0700, juma_gandhi_at_yahoo.com (Jumma) wrote:

>Hi,
>
>To continue this topic further, I would like to ask how we should find
>out the total amount of the transactions, which are currently
>performed in the database.
>The disadvantage, to find out the redo amount generated via CPODR_BNO
>column of SYS.X$KCCCP table, which we discussed earlier is that , via
>this process we can only find the redo amount generated for the
>current redo log file.
>
>But what we can do if a particular transaction is so huge, that its
>redo amount span over two or more redo log files.
>So as far as I know, we can’t find out the total amount of redo
>generated of this huge transaction using above procedure.
>
>Because the value of CPODR_BNO column of SYS.X$KCCCP table changes
>after every log switches. In our case log switches occur implicitly.
>
>So the bottom line is that how can we find out the total redo amount
>of a huge transaction(s).
>
>Thanks
>
>Juma

Clearly you are obsessed with redo log. If your application has been designed properly, redolog is not a concern. As I posted a few hours ago, use the logminer to find out the amount of redolog per transaction.

--
Sybrand Bakker, Senior Oracle DBA