Forum OpenACS Q&A: Response to Possible deadlock in transaction

Collapse
Posted by Rich Graves on
Adam, one way to see if and where Oracle is deadlocked is to open a second sqlplus session while the first is hung and see if you can select/update the relevant table(s) from there. If certain rows are locked you won't be able to manipulate those, etc.

...but I think Don's solution will work.