We ran into an issue recently where we would get deadlocks on Oracle 11g but not on 10g. After some investigation it turns out there is a change in how Oracle locks rows in 11g which means that insertions to a table with a foreign key also lock the candidate key in the referenced table!
The fix was to add indexes to the column in the referenced table so that Oracle can use this instead of locking the row.
This blog post by Richard Foote had a good explanation of the issue.
No comments:
Post a Comment