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