Stop long-running #SQL statements from Oracle Database 18c with ALTER SYSTEM CANCEL SQL '<sid>, <serial#>' To ensure the next statement runs, you can pass the SQL ID of the statement to stop - in case it finishes first! ALTER SYSTEM CANCEL SQL '<sid>, <serial#>, <sql_id>'
0
10
40
2K
18
Download Image