Friday , July 19 2024

How To Kill Running Query In Oracle

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.


About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *