How to set DEADLOCK_PRIORITY in Oracle
Hello,
There is quite useful feature in MS SQL Server: SET DEADLOCK_PRIORITY LOW
Specifies that the current session will be the deadlock victim if it is involved in a deadlock and other sessions involved in the deadlock chain have deadlock priority set to either NORMAL or HIGH.
I would like to use this option for background delete jobs, which are easily restartable, so it's selected as a deadlock victim rather than a common user transaction.
I know it's better to prevent deadlock, but it is quite difficult in some cases.