Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will answer the question of How to Kill a Running Sql Query in Oracle Database.
There is a SQL query that consumes a lot of resources on Oracle Database. Can I just end this SQL query without killing the session?
This feature has entered our lives with Oracle Database 18C.
Below is the syntax and sample query.
1 2 3 4 5 6 7 | /* Syntax */ ALTER SYSTEM CANCEL SQL 'SID, SERIAL[, @INST_ID][, SQL_ID]'; /* Example Query */ ALTER SYSTEM CANCEL SQL '1903, 882299, 14zvrtb88plz'; |
