Re: UNDO Issue
Date: Fri, 26 Jun 2009 21:37:08 +1000
The Magnet wrote,on my timestamp of 25/06/2009 11:12 PM:
> Also, I turned off archiving.
Yup, that definitely helps but has nothing to do with UNDO.
> And although I truncated some of the
> tables, the indexes may have been there, which may have been a
Bingo. The UNDO was consumed mostly by the index blocks being updated for every row inserted. Received on Fri Jun 26 2009 - 06:37:08 CDT