Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Proving or Debunking the need for rebuilding

Re: Proving or Debunking the need for rebuilding

From: <hasta_l3_at_hotmail.com>
Date: 27 Nov 2006 17:46:06 -0800
Message-ID: <1164678366.283195.119490@f16g2000cwb.googlegroups.com>


> >
> > 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 ?

Received on Mon Nov 27 2006 - 19:46:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US