On 4/10/07, fmhabash@xxxxxxxxx <fmhabash@xxxxxxxxx> wrote:
So if a table does witness this massive deletion with no subsequent significant DML or if there is an index on a some sequence generated value with sporadic deletions that leaves the leaves unused but keeps the nodes. These leaves are never back on the free list.
If you mean a DELETE that removes all data from an index leaf block, then that is incorrect. Empty index leaf blocks go back on the freelist. If the leaf block still has data in it, it can still be used. In the case of a sequence generated key though the space is unlikely to be reused. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist