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

Hello all --

Question - which optimizer hint would be the best at getting Oracle to do some sort of scan on the entire index (to touch all the index blocks, branch and leaf) to solve the delayed block cleanout problem after many deletes?

David P.

Jonathan Lewis wrote:
>
> 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 ?
> >
Received on Sun Mar 12 2000 - 00:00:00 CST