Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

You can query the lock tables, or if you are using a tool such as Toad, you can use the session browser to find possible locks.

Here's a link to oracle system tables

share|improve this answer
The lock tables show the waiting sessions and I could find out that there is a transaction that blocks. But that doesn't really help me because there's no more information about the transaction. This page has helped me: I'll probably find a way around the problem. – Wolfgang Oct 28 '09 at 12:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.