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

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

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


Other related posts: