Find wait reason in Oracle

Posted by thewolfgang on Server Fault See other posts from Server Fault or by thewolfgang
Published on 2009-10-28T09:16:05Z Indexed on 2010/04/02 4:09 UTC
Read the original article Hit count: 140

Filed under:

I'm running a Java application with an Oracle 10g. I've discovered kind of a race condition that leads to an inifite long waiting time for an UPDATE statement.

To solve this situation I'd like to find out what this statement is waiting for (locks on certain tables caused by statement xy etc.).

I tried to use the Oracle Enterprise Manager which has found this situation as well but it doesn't tell my the reason for the wait.

© Server Fault or respective owner

Related posts about Oracle