[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.