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 18.104.22.168.0 to 22.214.171.124.0 [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