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
Oracle
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