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

  • From: Andrey Kriushin <Andrey.Kriushin@xxxxxxxx>
  • To: david@xxxxxxxxxxxxxxxxxx
  • Date: Mon, 19 May 2008 03:56:53 +0400


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


Other related posts: