ALTER SYSTEM CANCEL SQL in the middle of a transaction

Community ForumCategory: DatabaseALTER SYSTEM CANCEL SQL in the middle of a transaction
matheusdba Staff asked 3 months ago

What happens if you cancel a SQL (ALTER SYSTEM CANCEL SQL) in the middle of a transaction?

1 Answers
matheusdba Staff answered 3 months ago

It happens the same as if you kill a session in the middle of a transaction. It gets rolled back.
For more info about the command, here are the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-processes.html#GUID-7D8E5E00-515D-4338-8B86-C2044F6D2957