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';
ALTER SYSTEM CANCEL SQL 'SID, SERIAL, @INST_ID, SQL_ID'; |
Sample :
– For the query in the corresponding session in the linked instance:
ALTER SYSTEM CANCEL SQL '123, 34789';
– For the query in the corresponding session in the 1-id instance:
ALTER SYSTEM CANCEL SQL '123, 34789, @ 1';
– For a specific query in the corresponding session in the linked instance:
ALTER SYSTEM CANCEL SQL '123, 34789, 5swu4fpw7x3pd';
– For a specific query in the corresponding session in the 1-id instance:
ALTER SYSTEM CANCEL SQL '123, 34789, @ 1, 5swu4fpw7x3pd';
– 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 '; |