Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Commit hangs when multiple Select 4 Updates taking place?
Hi Kevin,
Look in the alert log for deadlock messages. Sounds just like it.
The FOR UPDATE will lock the row(s). That is a potential source of deadlocks, and your application should deal with them.
Deadlocks is a very common problem and a lot of stuff about solving/handling them can be found out there, i.e. try searching google on "oracle deadlock".
On 4 Oct 2002 14:49:02 -0700, kyancy1_at_midsouth.rr.com (K. Yancy) wrote:
>Hi
>
>We have a situation with Oracle 8i where when multiple users are
>updating the same table using FOR UPDATE. They are using a Java
>application that is accessing the DB using the thin JDBC driver.
>
>Often one of these users COMMIT request will hang forever and all
>other users have to wait. The COMMIT will never timeout and the
>zombie DB connection will stay up until eventually Oracle will time it
>out and return it to pool.
>
>Has anyone ever seen a case where a COMMIT will just hang like that
>without returning an error or anything? I suspect that all the ....
>FOR UPDATEs have something to do with but I am in no way an Oracle
>expert.
>
>Thanx in advance for any suggestions
>
>kevin
Received on Fri Oct 04 2002 - 17:38:12 CDT