Sybrand Bakker wrote:
> 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
Or learn what SQL*Plus autotrace can do for you.
HJR
Received on Fri Aug 27 2004 - 06:12:25 CDT