Re: ORA-00060: deadlock detected while waiting for resource

On Mon, 05 Sep 2005 12:51:22 +0200, JBB <merci_at_pasdespam.fr> wrote:

>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

ora-0060 results automagically in a trace file in the user_dump_dest directory on the database server.

--
Sybrand Bakker, Senior Oracle DBA