Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Deadlock problems

Deadlock problems

From: Ludo <nospam_at_nospam.com>
Date: Mon, 22 Jul 2002 11:49:54 +0200
Message-ID: <ahgjuu$obh$1@reader1.imaginet.fr>


Hello,

I've some serious deadlock problem on a 4 instances program. Here is the log :

Initrans on ARO_APP_RIN is 16 since the creation of the table, and i'm sure it's not a applicative lock.

So is the "Current SQL statement for this session:" is always the last statement that lead to the deadlock ?
There are some trigger on ARO_APP_RIN, Is it possible that a statement in the trigger lead to this deadlock (the trigger work on tables whith initrans = 1)

Thanks for any help.

Ludo

--
Ludovic Cayen (Adventec)
Received on Mon Jul 22 2002 - 04:49:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US