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

> (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 Received on Tue Jun 20 2006 - 03:40:09 CDT