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.
/* Syntax */
ALTER SYSTEM CANCEL SQL 'SID, SERIAL[, @INST_ID][, SQL_ID]';
/* Example Query */
ALTER SYSTEM CANCEL SQL '1903, 882299, 14zvrtb88plz';