I execute a delete sentence in a table with a lot of information, this table has 4 secondary indexes. My process had 2 hours running but we decide to abort the job. It was a terrible error because we find that the process take more time in execute a rollback.
My question is
Are there some way for make that the abort work faster than in this moment? or What can I do to stop the abort?
I calculated the time for the rollback and I find that it will take 3 days, and it's not good news.
The information in the rollback its not important, I only want to stop the abort because it take a lot of resources and my reports in the server work very slow because the abort session is working and this reports are important for my users.