In past versions of Oracle whenever a database administrator needed to cancel a SQL query, the session that was running the SQL had to be killed. This meant the session had to be removed from the database and a new connection would have to be initiated. Now in Oracle 18c the SQL statement itself can be canceled and rolled back.
Here is the syntax of cancelling a SQL statement.
ALTER SYSTEM CANCEL SQL ‘SID, SERIAL’
SQL> alter system cancel sql ‘280,22827,3tfmdd4xagv3y’;
System altered.
Recent Posts