Re: RAC partitioning question
Date: Wed, 1 Feb 2012 09:15:32 +0000
Message-ID: <CAGdek=xDmwVi9=OweCJ5D48uvESU9zq6=KX=nyMQs0-xc8vvGg_at_mail.gmail.com>
On Tue, Jan 31, 2012 at 9:19 PM, Walker, Jed S <Jed_Walker_at_cable.comcast.com> wrote:
> Thanks again everyone for the ideas. I tried to push for changing the column but the application uses that instead of timestamp, well, I won't get into it, bad design is bad design eh?
Hi,
One more remark about global indexes and partition drop - yet it is possible online but you will "pay" for it. When Oracle is busy with dropping your partition and updating global index and application is doing inserts your index will growing faster during that activity. Next thing to remember is that Oracle is reading index block related to every dropped row in partition so dropping partition is not a cost less operation anymore.
After partition drop you should add index maintenance task to your
schedule - coalesce is fine for most of cases but if you are dropping
lot of rows you can end up with index rebuild as well. I create simple
test case here -
http://oracleprof.blogspot.com/2011/03/rolling-partition-and-global-index.html
. In real life I got a index which was 10 x bigger that is should
after 1 year of dropping daily partitions.
-- Marcin Przepiorowski http://oracleprof.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 01 2012 - 03:15:32 CST