SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

a month ago

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>'

Stop long-running #SQL statements from Oracle Database 18c with ALTER SYSTEM CANCEL SQL '&lt;sid&gt;, &lt;serial#&gt;' 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 '&lt;sid&gt;, &lt;serial#&gt;, &lt;sql_id&gt;'