what's "enq:TX - contention"
- From: "Eagle Fan" <eagle.f@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Nov 2007 00:19:11 +0800
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
Other related posts:
