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

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 - 16:49:02 CDT