Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Effective deadlock handling
On Mon, 05 Jan 2004, damorgan_at_x.washington.edu wrote:
> The records stay in the "deadlocked" state until the
> transaction is completed by either a commit or rollback. So the
> problem is also mostly solvable by performing incremental
> commits.
A single transaction involving multiple SQL statements should be broken up and commits should be issued throughout? Are you going to have a clean-up process for this as well?
-- Galen BoyerReceived on Mon Jan 05 2004 - 15:06:13 CST
![]() |
![]() |