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.