Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rollback is taking ages

537728Jun 6 2007 — edited Jun 7 2007
I am deleting old data from a big table, first I deleted 2 million rows with no problems, it took 5 minutes.
I did commit with no problems.
Then I tried to delete another 8 millon rows. After 3 hours the query was still running so I killed the session.
That was a couple of hours ago and the session is still marked as killed but the rollback seems to take forever and ever.
I am the only one working against this table.

Is there any way to calculate how much time will it take to terminate the session?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2007
Added on Jun 6 2007
3 comments
1,058 views