Re: Causes for "Enq: TM - contention" on a table with conventional path insert?
From: Andrey Kriushin <Andrey.Kriushin_at_rdtex.ru>
Date: Mon, 19 May 2008 03:56:53 +0400
Message-ID: <4830C245.9000302@rdtex.ru>
Date: Mon, 19 May 2008 03:56:53 +0400
Message-ID: <4830C245.9000302@rdtex.ru>
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
Received on Sun May 18 2008 - 18:56:53 CDT