Re: Proving or Debunking the need for rebuilding

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 28 Nov 2006 10:27:36 -0800
Message-ID: <1164738455.964656.107250@l39g2000cwd.googlegroups.com>

hasta_l3_at_hotmail.com wrote:
> > >
> > > Is it possible what the OP is seeing is a delayed block cleanout?
> >
> > I think it is entirely possible. I'm wondering if simply doing a
> > count(*) that uses the index in question, before performing each test,
> > might shed light one way or the other. The idea is to visit all blocks
> > and clean them.
> >
>
> We are deleting in a bunch of small transactions.
> We should have (almost) no delayed block cleanouts, right ?
>
> --- Raoul

Yes that's correct. See Tom's writeup in chapter 9 of Expert Oracle Database Architecture. Received on Tue Nov 28 2006 - 12:27:36 CST