Oracle Scratchpad

September 19, 2009

Index ITLs

Filed under: Index Explosion,Indexing,Infrastructure,Performance,Troubleshooting — Jonathan Lewis @ 3:35 pm BST Sep 19,2009

After wrting a short series of notes on a problem with indexes wasting a lot of space and growing to three (or even four) times the size you might expect due to a problem with concurrency and ITL (interested transaction list) entries accumulating, I thought it would be a good idea to create a little index for the series to make it easier to read them in order:


  1. […] handle leaf node splits that can appear even at fairly low levels of concurrency . This results in excess ITL entries being allocated in the new leaf nodes. Once the ITL entires have been allocated they are always propagated across […]

    Pingback by Index Efficiency 3 « Oracle Scratchpad — March 3, 2010 @ 9:21 pm GMT Mar 3,2010 | Reply

  2. […] transaction list), how and when they become huge and make index bigger in size – see this post with links to several other articles. As it turned out in a recent thread on forum, one of […]

    Pingback by Index ITL « Timur Akhmadeev's blog — April 27, 2010 @ 7:57 pm BST Apr 27,2010 | Reply

  3. […] have written several notes about a problem with leaf block splits that used to appear occasionally in systems that used […]

    Pingback by Fragmentation 4 « Oracle Scratchpad — July 22, 2010 @ 7:02 pm BST Jul 22,2010 | Reply

RSS feed for comments on this post.

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: