Re: what's "enq:TX - contention"
- From: "Eagle Fan" <eagle.f@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- Date: Mon, 17 Dec 2007 13:43:44 +0800
The sessions were waiting on TX-4.
We can't find the blocker.
Thanks
On Nov 30, 2007 12:04 AM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
> When this is happening, in what mode is the lock being held? (I assume
> 'X'.) In what mode is the waiting lock? ('S' mode?)
>
>
>
> -Mark
>
>
>
> *--
> Mark J. Bobak*
> *Senior Database Administrator, System & Product Technologies*
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak@xxxxxxxxxxxxxxx
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Eagle Fan
> *Sent:* Thursday, November 29, 2007 3:05 AM
> *To:* oracle-l
> *Subject:* Re: what's "enq:TX - contention"
>
>
>
> any comments?
>
> Thanks
>
> On Nov 27, 2007 12:19 AM, Eagle Fan <eagle.f@xxxxxxxxx> 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
>
--
Eagle Fan
Oracle DBA
Other related posts:
