Oracle 18C新特性：ALTER SYSTEM CANCEL SQL

SQL> select sid, serial# from v$session where sid = userenv(‘SID‘); SID SERIAL# ---------- ---------- 25 29476 SQL> create table t_source as select * from dba_source where 1=2; Table created. SQL> select count(*) from t_source; COUNT(*) ---------- 0 SQL> insert into t_source select * from dba_source; 292640 rows created. <========================== 备注此时的总记录数 SQL> insert into t_source select * from dba_source;

正在执行第2次insert时，在另外一个session执行取消操作。

##session 2
SQL> alter system cancel sql ‘25,29476‘;
System altered.

检查session 1 此时的执行信息。

##session 1
SQL>  insert into t_source select * from dba_source;
 insert into t_source select * from dba_source
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation

SQL> select count(*) from t_source;

  COUNT(*)
----------
    292640                         <========================== 记录数和第2次插入之前一样

这里可以看到第2次插入的记录已经回滚。

 

Oracle 18C新特性：ALTER SYSTEM CANCEL SQL

标签：mic   sys   cancel   sele   信息   image   alt   weight   source