Re: Strange Behaviour on Index Space Usage, help please

It is the same.

And just to add a little more, you can be in a position where the block can never be
visited, in which case a dirty block might never be cleaned, and therefore never become available for re-use. This is less likely in the era of fast-commits and delayed logging block cleanout, but for large deletes it is still possible.

--

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

Connor McDonald wrote in message <396DC256.3ECB_at_yahoo.com>...


>Just to add some more...

>

>In V7, the space in an totally free block was only available after a

>commit, thus

>

>delete from blah

>insert into blah select ...

>

>would not reuse the space freed by the delete, whereas

>

>delete from blah

>commit

>insert into blah select ...

>

>would be able to...

>

>I haven't confirmed for V8 but I would suspect the same.