Re: Causes for "Enq: TM - contention" on a table with conventional path insert?
Date: Mon, 19 May 2008 11:23:11 -0700 (PDT)
Message-ID: <159893.51158.qm@web804.biz.mail.mud.yahoo.com>
Thanks for the info Nilo.
Sadly for me, none of these fit the case I'm looking at.
- Original Message ---- From: Nilo Segura <nilosegura_at_gmail.com> To: Andrey.Kriushin_at_rdtex.ru Cc: david_at_david-aldridge.com; Oracle List <oracle-l_at_freelists.org> 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_at_rdtex.ru> 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
--
http://www.freelists.org/webpage/oracle-l
--
Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 19 2008 - 13:23:11 CDT