Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Tue Jun 20 2006 - 23:52:26 CDT