Re: a heated discussion between Development Team & "a" DBA: reorg or not to reog

OldDBA wrote:
> You obviously didn't read my followup. To clarify, I said that the
> space would be reused for future inserts or updates. if there is index
> data that logically fits into the space freed in the b-tree the index
> data will be placed there. However, the extent will not be placed on
> the freelist until all of the data in the entire block has been
> deleted. This effectively causes fragmentation (and potential growth)
> of the index and would call for a possible rebuild.
>
> Has anyone else heard the substance of the problem.

Never in 17 years with Oracle and with applications in the many TB and with many thousands of users.

BTW: If you snip the entire thread the context is lost.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)