UPDATE child_table SET ...; UPDATE parent_table SET ...; COMMIT;This will perform the updates at relatively the same time and commit them both as one transaction.
The next thing to check is to ensure that your UPDATE statement is optimal. If your UPDATE statement takes 15 minutes...
to complete, then you have a 15-minute window where you could have a deadlock condition. Optimize your UPDATE statements just as you would optimize any SQL statement. Ensure that your UPDATE statements are using indexes where appropriate, etc.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.