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

On 13 Aug 2005 13:40:39 -0700, "hansdegit_at_hotmail.com" <hansdegit_at_hotmail.com> wrote:

>Now, here's my question: could the slow i/o have something to do with
>the continuing claims for new undo space in the undo tablespace? Could
>it be that, due to the slow io, SMON just could not find the time to
>tidy up a bit?

You need to use v$waitstat to monitor what your process is waiting for.
Provided you didn't set up dictionary managed tablespaces your assumption is highly unlikely and probably just a shot in the dark.

Other than that, one could question why you don't merge the insert and update into one statement, assuming the *real* update statement (which you obviously didn't disclose) is as simple as the pseudo statement you provided.

--
Sybrand Bakker, Senior Oracle DBA