[20181107]18c新特性取消运行的sql.txt

[20181107]18c新特性取消运行的sql.txt --//18c有一个新特性,取消正在运行的sql语句.通过例子演示: 1.环境: SQL> select banner_full from v$version; BANNER_FULL -------------------------------------------------------------------------------- Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> select sid,serial# from v$session where sid in (select sid from v$mystat where rownum=1);        SID    SERIAL# ---------- ----------          9      19953 SQL> set feedback 6 sql_id SQL> select count(*) from dba_tables,dba_tables;   COUNT(*) ----------    4618201 SQL_ID: 67whmvp7skh6r --//或者这样确定sql_id. SQL>  select sql_text,sql_id from v$sql where sql_text like '%dba_tables%'; SQL_TEXT                                                             SQL_ID -------------------------------------------------------------------- ------------- select sql_text,sql_id from v$sql where sql_text like '%dba_tables%' 4kjzfqnnm15ng select count(*) from dba_tables,dba_tables                           67whmvp7skh6r 2.再次执行: SQL> select count(*) from dba_tables,dba_tables; select count(*) from dba_tables,dba_tables                      * ERROR at line 1: ORA-01013: user requested cancel of current operation --//打开另外会话,执行: SQL> alter system cancel sql '392,13330,67whmvp7skh6r'; System altered. --//取消真正运行的sql_id.