Wednesday, November 11, 2009

enq: TX - allocate ITL

When you see this enqueue wait event in the dbconsole performance page or in the top 5 timed waits event seems that too many concurrent DML transactions are competing for the same data block.

Usually an increase in the value of initrans or maxtrans for the table and the indexes fixes the problem.

You can also try to move the table to a tablespace with smaller block size and reduce the parallel degree of the table and indexes.

1 comment:

  1. the B-tree index is widely used in many applications
    in some cases and if the primary key is an incremented value, the bottleneck is usually a the last branch blocks of the index.
    in this case the reverse key order may be used an an alternative solution

    ReplyDelete