My Oracle Support Banner

How To Cancel A SQL Query In 18c (Doc ID 2471181.1)

Last updated on JANUARY 29, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 18]
Information in this document applies to any platform.


The idea of this document is to explain the steps to cancel a query in 18c, in this version you have the option to cancel just the query instead of terminate the session.

The following clauses are required in an ALTER SYSTEM CANCEL SQL statement:

    SID – Session ID
    SERIAL – Session serial number



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.