by Ahmet Duruöz
With the new feature that comes with Oracle 18c, it is now possible to stop the running query without logging off. With 18c it is now possible to manually stop the query as follows.
Use of :
|
ALTER SYSTEM CANCEL SQL 'SID, SERIAL, @INST_ID, SQL_ID'; |
Sample :
|
– BAğlI when the instanceFor the query in the corresponding session in ALTER SYSTEM CANCEL SQL '123, 34 789'; – 1 id 'li instanceFor the query in the corresponding session in ALTER SYSTEM CANCEL SQL '123, 34 789, @one'; – Connected instance 'on about in the session specific one query Içof: ALTER SYSTEM CANCEL SQL '123, 34789, 5swu4fpw7x3pd'; – one ID'instance'on about in the session specific one query Içof: ALTER SYSTEM CANCEL SQL 123, 34789, @ 1, 5swu4fpw7x3pd '; |
