Re: Index size growing abnormally .....Oracle bug ?

Just tested it.

The answer is yes.

As a side effect,

    update test_reuse set idx_col = idx_col + 0.5     where idx_col = 100;

can cause a block to split if the block is full and the update entry is supposed to stay in that block.

Then I found that things could be worse when the consequences of fast commit and
delayed logging block cleanout apply.

More details when I have investigated fully.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <38C9BF80.7D82_at_yahoo.com>...


>

>I've always thought that if you deleted (even all of the) entries from

>an index block then it only becomes available for re-use for insert

>after the delete has committed.

>

>Is this true ?

>