Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Avoiding deadlocks by setting priorities per Session/user?

2880058Feb 6 2015 — edited Feb 7 2015

The question is, if it is possible to avoid the abortion of a high priority process (in this case for the business) when a deadlock comes up and rather abort the other process running with a non-priority set up or lower priority.

Something as in SQL Server function called DEADLOCK_PRIORITY.

Maybe configuring a high priority user/session which no process can stop its execution?

Thanks in advance for your comments, that will be very useful in our research,

Regards

This post has been answered by Jonathan Lewis on Feb 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2015
Added on Feb 6 2015
6 comments
1,407 views