Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: what's "enq:TX - contention"

Re: what's "enq:TX - contention"

From: Eagle Fan <eagle.f_at_gmail.com>
Date: Thu, 29 Nov 2007 16:05:00 +0800
Message-ID: <4415a5ed0711290005r4217052bmcf669f41c15bc0f3@mail.gmail.com>


any comments?

Thanks

On Nov 27, 2007 12:19 AM, Eagle Fan <eagle.f_at_gmail.com> wrote:

> hi:
>
> In 10g, oracle has four TX wait events:
>
> 1. enq:TX - row lock contention
> 2. enq:TX - index contention
> 3. enq:TX - ITL
> 4. enq:TX - contention
>
> I know the first three ones' meanings.
>
> But what does the last one "enq:TX - contention" mean? I know it means
> other TX enqueue types. But what's the *other* TX enqueues?
>
> Could anybody give me some examples? We have insert sql causes this TX
> contention.
>
> I searched metalink and oracle-l, but most doc/threads are discussing the
> first three ones.
>
> Thanks a lot.
>
> --
> Eagle Fan
>
> Oracle DBA
>

-- 
Eagle Fan

Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 29 2007 - 02:05:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US