SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL UPDATE hangs, or undetected deadlock

696884Apr 17 2009 — edited May 6 2009

Hi,

I have a SQL UPDATE statement that will sometimes hang without ever timing out nor throwing any deadlock error. I cannot reproduce this problem at will, but looking in the application, I was able to spot a potential cause of deadlock.

My quesiton is: Is it possible that Oracle will not detect some deadlock, and that my UPDATE will just hang without returning any error ?

If the answer is that oracle detects all deadlocks, then I would have to look for a performance problem with my SQL UPDATE that makes it hang for what looks like forever. The problem with that alternative is that this update executes very very fast when it does not hang (and it hangs very very rarely). This is on oracle 10.2.0.1.

Thanks,

--
Mel T.
Oracle dummy

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2009

Added on Apr 17 2009

9 comments

5,109 views