Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
1  
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: orafaq.com/node/854 I'll probably find a way around the problem. –  Wolfgang Oct 28 '09 at 12:26
add comment

Your Answer

 
discard

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.