Oracle 18c new feature: ALTER SYSTEM CANCEL SQL

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

EXAMPLE

For the query in the corresponding session in the instance you are connected to:

For a specific query in the corresponding session in the instance you are connected to:

For the query in the corresponding session in the instance 1:

For a specific query in the corresponding session in the instance 1:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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