what's "enq:TX - contention"

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 26 2007 - 10:19:11 CST