Howard J. Rogers wrote:
> 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
Or Use V$sessstat to find the redo size Statistc# 115
HTH
Ganesh
Received on Fri Aug 27 2004 - 09:44:32 CDT
