ALTER SYSTEM CANCEL SQL in the middle of a transaction

Community Forum › Category: Database › ALTER SYSTEM CANCEL SQL in the middle of a transaction

0 Vote Up Vote Down

matheusdba Staff asked 3 years ago

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

Question Tags: plsqlbestpractices, yatra20

1 Answers

0 Vote Up Vote Down

matheusdba Staff answered 3 years 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