Re: How to know how long a Rollback will take

Mark,

Great stuff!!! I ran the first formatted query and clearly see my transaction and see that the USED_UBLK has 237,000 blocks and is decreasing at the rate of 500 blocks per minute, so it will take 8 hours to rollback. (Correct me if my logic is wrong there).

One other question. This happened during an import and I do not want or need the data that is being rolled back. I could drop/recreate the table entirely and discard all previous data and rollback data. Is there a way to just 'pull the plug' on the rollback and stop it entirely? Is so, what are the risks?

Thanks alot for your help.
Dan

Mark D Powell wrote:
> 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 - 09:14:48 CDT