alter system cancel sql terminates an SQL statement being executed. alter system cancel sql 'sid serial'; alter system cancel sql 'sid serial@instance_id'; alter system cancel sql 'sid serial sql_id'; alter system cancel sql 'sid serial@instance_id sql_id';