ORA-00060: deadlock detected while waiting for resource

This exception appears somme times in my application. It raises a Java exception in my program.

For a deadlock there must be two 'process' ( db connection ) involved. One of these is easily identified because it raises the exception. But how to know what is the other process that is blocked ( and deblocked when I rollback the process in exception).

Are there exceptions traces in oracle ?

Thanks Received on Mon Sep 05 2005 - 05:51:22 CDT