Re: UNDO Issue

From: Noons <>
Date: Fri, 26 Jun 2009 21:37:08 +1000
Message-ID: <h22bsi$kar$>

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

Original text of this message