oracle 如何在oracle sql developer中停止任务

How to stop task in oracle sql developer

提问by Xiaoqing

I ran a script in Oracle sql developer last night which is a quite simple command: 'update TABLE set column A=...' The table is a large one maybe about 70GB. The task kept running for the whole night and still running.... Could I just click on the stop button on the window? I'm afraid of locking the session or the rolling back procedure will take longer time.

昨晚我在 Oracle sql developer 中运行了一个脚本，这是一个非常简单的命令：'update TABLE set column A=...' 该表很大，可能大约 70GB。任务一整夜都在运行，还在运行....我可以点击窗口上的停止按钮吗？我担心锁定会话或回滚过程需要更长的时间。

So what will happen to the database after we click stop? Or is there a more efficient way to kill task...

那么我们点击停止后数据库会发生什么？或者有没有更有效的方法来杀死任务......

采纳答案by Ravi

I would recommend not to stop it from SQL Developer instead you can get the session id from V$SESSIONof this connection and kill it

我建议不要从 SQL Developer 停止它，而是可以从这个连接的V$SESSION获取会话 ID并杀死它

alter system kill session 'sid,serial#';