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

I've never checked that theory - it is
possible, but sounds a little suspect.
(chalk up number 237 for the todo list).

The post I was responding too said
nothing about doing any deletes at
all, though, which is why it is harder
to come up with a realistic 'normal'
reason for dropping below 50% usage.

--

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 ?

>

>Could this be a (part) explanation for the index problem the original

>poster had...ie "lots of deletes, lots of inserts then commit" causing

>of deleted space not being re-used.

>