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

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 Received on Fri Aug 27 2004 - 03:15:51 CDT