How To Kill Running Query In Oracle

Buğra PARLAYAN

10 months ago

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';

/* Syntax */

ALTER SYSTEM CANCEL SQL 'SID, SERIAL[, @INST_ID][, SQL_ID]';

/* Example Query */

ALTER SYSTEM CANCEL SQL '1903, 882299, 14zvrtb88plz';