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:
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