In any case, I cannot reproduce - you'll have to show us how to step by step by step: [email protected] For example, it is possible that the rows in SO_LINE_DETAILS can be locked before the rows in SO_PICKING_LINE_DETAILS.If one user ran this query under the RBO, and another user ran this query under the CBO, locking order issues could arise due to the likelihood of a plan difference.
From this it looks like the data that is selected for update has an impact on how SELECT FOR UPDATE works.
supply a complete test case including o create table statement o any and all indexes o inserts My example did not even have a primary key...
Chat, hang out, and hook up with new people in your area by joining the site that's frequently ranked in the top 10 dating websites.
Forget speed dating, classified personals, or other dating sites or chat rooms, DH is the best!
DEPARTURE_ID FOR UPDATE NOWAIT; The problem with this query is that the locking order is largely dependent on the execution plan and the row source order.
My question is, is there any relation between the usage of SELECT FOR UPDATE clause and the primary key of a table?
Also, please remember for the multi-select options that selecting all items is the same as selecting no items.
Start meeting singles near you now, and don't let your wallet get in the way of finding love.
Handling other types of variables, such as integers, would have made the example longer.