RE: Transactions waiting for Lock on Rollback Segments

From: kgopal <kgopal_at_mantraonline.com>
Date: Wed, 24 May 2000 14:40:01
Message-Id: <10507.106492@fatcity.com>

Hi vivek !

>What does ITL stand for ?

ITS stands for

Interested
Transaction
List..

In simple words it is like a gate pass entry for the transactions modifying the data block.

Any transaction modifying the datablock should made an ITL entry for that particular block. The number of ITL entries for any datablock is governed by the INITRANS parameter. This defaults to unique (for Tables and 2 for Indexes).

That means by default not more than one transaction can update (of any DML) on that datablock. If your database is very DML intensive you can consider increasing the ITL entry by setting INITRANS to higher values. But remember each ITL entry consumes 23 bytes of block space..

K Gopalakrishnan Received on Wed May 24 2000 - 14:40:01 CDT