Hi
From 12cR2 and 18c, you can cancel the session instead of killing it which is long running and consuming time and resources. The following is the syntax for cancelling a SQL statement:
ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’;
If @INST_ID is not specified, the instance ID of the current session is used. […]
Follow Me!!!