如何停止oracle撤消过程? [英] How to stop oracle undo process?

问题描述

我想知道如何停止oracle的撤消过程?我试图删除一个大表的数百万行，并且在进程的中间我杀死了会话，但是它开始撤消删除操作，并且大约两个小时后，数据库的运行速度大大降低.我不希望撤消过程继续进行.有什么办法可以阻止它?

I want to know how to stop undo process of oracle ? I tried to delete millions of rows of a big table and in the middle of process I killed session but It started to undo delete and for a bout two hours database got dramatically slow. I didn't want the undo process to be continued. Is there any way to stop it ?

推荐答案

逐行删除过程可能非常慢.如果删除操作都是在单个事务中完成的(如此处所示)，则删除速度可能会变慢.您可能需要考虑以下选项:

Row-by-row delete processes can, as you've found, be exceedingly slow. If the deletions are all done in a single transaction, as appears to be the case here, they can become even slower. You might want to consider the following options:

1. 如果要删除表中的所有行，则可能要考虑使用如果不删除表中的所有行，则应在删除一定数量的行后将过程更改为COMMIT.

   If you're not deleting all the rows in the table you should probably change your procedure to COMMIT after a certain number of rows are deleted.

   与此同时，您将不得不等到回滚过程完成.

   In the meantime you're going to have to wait until that rollback process completes.

   分享并享受.

   这篇关于如何停止oracle撤消过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！