Re: undo tablespace keeps growing, why can't I reclaim space?

From: <hansdegit_at_hotmail.com>
Date: 17 Aug 2005 13:07:31 -0700
Message-ID: <1124309251.166954.31150@g49g2000cwa.googlegroups.com>

hansdegit_at_hotmail.com schreef:

Well guys (and girls), strange as it is: now that the IO system has been configured properly, the same batch ( I repeat: the exact same batch) runs in 50 minutes and consumes less than 4 gigs of undo space.

My theory is: Oracle will use not reuse undo space when there is space available. Also, when IO due to cleaning up of undo space doesn't get through or simply is not performed fast enough, Oracle will postpone these activities until some time in the future.

While I write this down, I'm having more difficulties believing this.

Open invitation on the real guru's: please explain how this mechanism works. Received on Wed Aug 17 2005 - 15:07:31 CDT