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
Depends!
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 27 2006 - 22:41:44 CST
