Re: UNDO Issue

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 26 Jun 2009 21:37:08 +1000
Message-ID: <h22bsi$kar$3_at_news.eternal-september.org>

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
> factor....

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