Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Proving or Debunking the need for rebuilding
> >
> > 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 ?