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

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC internals - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED

Re: RAC internals - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED

From: Dusan Bolek <spambin_at_seznam.cz>
Date: 3 Nov 2005 08:39:45 -0800
Message-ID: <1131035985.315002.210070@f14g2000cwb.googlegroups.com>


Thank you, Jonathan. That looks very interesting. Unfortunately, the code accessing this database is too complex to be investigated in this way. However, I have got from dba_constraints all referential constraints without associated index that were created with ON DELETE CASCADE. There are twelve of them and I will ask the guy responsible for this database to create appropriate indexes for all of them. Maybe that will solve the problem.

--
Dusan Bolek
Received on Thu Nov 03 2005 - 10:39:45 CST

Original text of this message

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