Re: Causes for "Enq: TM - contention" on a table with conventional path insert?

  • From: David Aldridge <david@xxxxxxxxxxxxxxxxxx>
  • To: Nilo Segura <nilosegura@xxxxxxxxx>, Andrey.Kriushin@xxxxxxxx
  • Date: Mon, 19 May 2008 11:23:11 -0700 (PDT)

Thanks for the info Nilo.

Sadly for me, none of these fit the case I'm looking at.


----- Original Message ----
From: Nilo Segura <nilosegura@xxxxxxxxx>
To: Andrey.Kriushin@xxxxxxxx
Cc: david@xxxxxxxxxxxxxxxxxx; Oracle List <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, May 19, 2008 3:45:02 AM
Subject: Re: Causes for "Enq: TM - contention" on a table with conventional 
path insert?

Hi,

Could you check if your problem may fit the following bug numbers ?

bug : 6053354
bug : 3801750



On Mon, May 19, 2008 at 1:56 AM, Andrey Kriushin <Andrey.Kriushin@xxxxxxxx> 
wrote:

Hi,

there should be  something  hidden behind the scenes... I've failed to 
reproduce the behaviour you've
described (TM eXclusive lock) as well.

ALTER TABLE xxx DISABLE LOCKING may probably help. However, I'd try to find the 
root cause
of X-lock beforehand.

-- Andrey

--
//www.freelists.org/webpage/oracle-l






-- 
Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland

Other related posts: