Re: Commit hangs when multiple Select 4 Updates taking place?

From: Liggs <liggs_at_hotmail.com>
Date: Sat, 5 Oct 2002 14:38:04 +0000 (UTC)
Message-ID: <anmtgc$qkk$1@paris.btinternet.com>

It sounds like they are trying to update the same rows or you need to index all your foreign key columns.
If you are updating the same rows, then yes, oracle with wait until the transaction commits or rolls back.
Its not a primary key they are updating is it? Is it updating just the one column row, or re-updating the same data in other columns too (redundant but it can cause problems).

You probably need to re-evaluate the way these rows can be updated, is they any other way of achieving the same ends?

Liggs

"K. Yancy" <kyancy1_at_midsouth.rr.com> wrote in message news:941c889c.0210041349.941bc69_at_posting.google.com...
> 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 Sat Oct 05 2002 - 09:38:04 CDT