Re: Fw: Defragmenting paper (what does ITL stand for?)

ITL stands for Interested Transaction List. I'm sure someone else can phrase this more succinctly, but this is the list that Oracle uses to keep track of DML operations on the rows within a data or index block. In order for a tx to change a row in a table, for example, it must obtain a slot in the ITL for the block in which the row is contained so that Oracle can maintain information about the tx, such as the RBS info needed to rollback the tx or for read consistency, etc...

Comments and corrections welcome.

• Anita

>From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Fw: Defragmenting paper
>Date: Wed, 03 May 2000 05:55:45 -0800
>
>I am forwarding this to the lists. I don't have the answer. Ruth
>----- Original Message -----
>To: <rgramolini_at_tax.state.vt.us>
>Sent: Tuesday, May 02, 2000 3:28 PM
>
>
>This is an interesting paper, Ruth.
>Could I ask you a question?
>What does ITL stand for (this is used in Index (B+Tree) Management)?
>Thanks,
>Fabio
>
>-----Original Message-----
>Sent: Terga-feira, 2 de Maio de 2000 15:42
>To: fabio.aneas
>Cc: rgramolini
>
>
>Here it is. HTH Ruth
>----- Original Message -----
>To: <rgramolini_at_tax.state.vt.us>
>Sent: Tuesday, May 02, 2000 2:35 PM
>
>
>I would apreciate if you sent it to me.
>Thanks,
>Fabio
>
>-----Original Message-----
>Sent: Terga-feira, 2 de Maio de 2000 15:18
>To: ORACLE-L; oracledba
>Cc: rgramolini
>
>
>Scott Shafer sent me an Adobe file with the paper 'How to Stop
>Defragmenting
>and Start Living: The Definitive Word on Fragmentation' and I will be
>glad
>to forward same to anyone who wants it.
>
>Ruth B. Gramolini
>ORACLE DBA
>VT Dept. of Taxes
>ph# 802.828.5708
>fax# 802.828..3754
>rgramolini_at_tax.state.vt.us
>
>
>--------
>If you're bored, then visit the list's website: http://www.lazydba.com
>(updated daily)
>to unsubscribe, send a blank email to
>oracledba-unsubscribe_at_quickdoc.co.uk
>to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
>
>
>
>
>
>
><< BDY.TXT >>