Re: RAC partitioning question

From: Marcin Przepiorowski <>
Date: Wed, 1 Feb 2012 13:24:10 +0000
Message-ID: <>

On Wed, Feb 1, 2012 at 11:40 AM, Jonathan Lewis <> wrote:
> Marcin,
> I've had a look at the blog item, and don't think it's really making a
> point that's restricted to partitioning.
> Any time you have mechanisms that only ever add data at the right hand side
> of an index, and then have bulk deletes scattered randomly through the
> entire length of the index, the utilisation of the average leaf block is
> bound to drop slowly over a number of delete cycles. This will happen
> whether or not you're talking about partitioning.

Hi Jonathan,

Thanks for you comment.
I realize that this is not restricted to partitioning only but I found out that during partition drop index is growing faster - even with same insert rate.
I'm going to check it again and use you script as well.

Marcin Przepiorowski
Received on Wed Feb 01 2012 - 07:24:10 CST

Original text of this message