Re: Undo tablespace grew 8 times larger the normal within two hours

On Sun, 01 Oct 2006 23:37:39 +0200, Mike wrote:

> What are the possible reasons that the undo tablespace grew so large and
> rapidly?

My tea leaves tell me that the problem probably lies in the triggers.

> What could I do to prevent the undo tablespace from growing out
> of proportion?

Fix the code that causes them to grow. If I were you, I would concentrate on triggers.

> Alter the table to be a nologging table?

How comes I didn't think of that? What exactly will making the table "nologging" do to the undo space?

-- 
http://www.mladen-gogala.com