Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a session without terminating session. You can stop the query as follows.
SYNTAX
1 | ALTER SYSTEM CANCEL SQL 'SID, SERIAL, @INST_ID, SQL_ID'; |
EXAMPLE
For the query in the corresponding session in the instance you are connected to:
1 | ALTER SYSTEM CANCEL SQL '123, 34789'; |
For a specific query in the corresponding session in the instance you are connected to:
1 | ALTER SYSTEM CANCEL SQL '123, 34789, 5swu4fpw7x3pd'; |
For the query in the corresponding session in the instance 1:
1 | ALTER SYSTEM CANCEL SQL '123, 34789, @1'; |
For a specific query in the corresponding session in the instance 1:
1 | ALTER SYSTEM CANCEL SQL '123, 34789, @1, 5swu4fpw7x3pd'; |
