enq: TM contention

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Fri, 16 Dec 2011 07:32:43 -0700
Message-ID: <CAJzM94DcUE=tLo1pGC6DDGsJ1LBRm0Fsrx_0M876GonYV_JmUA_at_mail.gmail.com>



Oracle EE 10.2.0.5

We have been experiencing periods where we see a lot of enq: TM contention waits. Customers notice performance degradation. Generally it clears on its own within 10 minutes or so. The only cause I've been able to locate in my searches (both google & MOS) is a non-indexed foreign key. This is definitely not the cause in our case. I haven't had an unindexed foreign key in over 2 years and verified it hadn't popped up unexpectedly.

Does anyone know of another possibility for causing this wait?

--

Sandy
Transzap, Inc.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 16 2011 - 08:32:43 CST

Original text of this message