ITL Waits

posted May 7, 2012, 4:50 PM by Sachchida Ojha
Oracle's row level locking implementation achieves a high-degree of scalability by maintaining lists of row level locks in each data block rather than in some centralized data structure. This list is called ITL (interested transaction list).

ITL depends upon following create table parameter.

1. INITRANS --> No of entries that will be available in each block when first created.

2. PCTFREE ---> Keeps some room in the block free for rows to grow when updated and also for the ITL to grow.

3. MAXTRANS --->Setting the very low value of MAXTRANS will have the same effect as setting very low value of PCTFREE.

Click here to see what Arup says about ITL,