SQL Language (MOSC)

MOSC Banner

How to set DEADLOCK_PRIORITY in Oracle

edited Jun 23, 2018 5:00AM in SQL Language (MOSC) 5 commentsAnswered ✓

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.

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-deadlock-priority-transact-sql?view=sql-server-2017

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center