Re: How to know how long a Rollback will take

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Sep 2006 06:42:05 -0700
Message-ID: <1159537325.233590.269680@m7g2000cwm.googlegroups.com>

Dan wrote:
> I did an import that failed to extend the UNDO segment of my database.
> I realize I need to use commit=y to overcome this issue. However, the
> database is rolling back the records it imported before hitting the
> error. This can take several hours.
>
> Is there a way to determine how much longer the rolling back will take?
> Is there a view or a process that I can get an idea of this?
>
> Thanks,
> Dan

Dan, I wrote this article a few years back. There might be a better way now but this still works fine:

Is there a way to detect processes that are rolling back, and can I figure out how long it will take ?
http://www.jlcomp.demon.co.uk/faq/rolling_back.html

HTH -- Mark D Powell -- Received on Fri Sep 29 2006 - 08:42:05 CDT