Re: Transactions requires much more UNDO space than expected....

On 20 Jun 2006 01:40:09 -0700, mccmx_at_hotmail.com wrote:

>> (measuring undo is pretty easy as you only need to
>>
>> set autotrace on explain stat
>>
>> prior to the first statement you want to measure.
>>
>
>Hmmm, pretty easy eh...? OK, which of the following stats tells me how
>much UNDO I have generated..?!?
>
>Statistics
>-------------------------------------------------------
> 0 recursive calls
> 7 db block gets
> 0 consistent gets
> 0 physical reads
> 0 redo size
> 421 bytes sent via SQL*Net to client
> 384 bytes received via SQL*Net from client
> 2 SQL*Net roundtrips to/from client
> 0 sorts (memory)
> 0 sorts (disk)
> 1 rows processed
>
>Matt

obviously redo size

--
Sybrand Bakker, Senior Oracle DBA