Re: deadlock

From: Jaap W. van Dijk <j.w.vandijk_at_kpn.com>
Date: 12 Sep 2000 14:54:05 GMT
Message-ID: <01c01cc9$4c592a10$942a15ac@HKTGN0003049994>

You can find information in the tracefile that is generated, it shows the statement that is rolled back because of the deadlock, and in case of a recordlock, the object_id and rowid of the locked record. For details see note 62365.1 on the Oracle metalink.

Jaap.

stuartirvine_at_my-deja.com schreef in artikel <8pldbd$fp8$1_at_nnrp1.deja.com>...
> I am getting the following in my alert log
>
> ORA-00060: deadlock detected while waiting for resource
>
> What would be the best course of action to resolve this problem ??
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Tue Sep 12 2000 - 09:54:05 CDT