Re: Merge partitions

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 16 Dec 2006 16:42:13 -0800
Message-ID: <1166316133.065694.223680@79g2000cws.googlegroups.com>

Mladen Gogala wrote:
> I am doing partition merge for a table with 160 million rows and it
> is taking forever (20 hours so far).
> Oracle version is 10.2.0.2(RAC) on Linux x86-64, the other instance is in
> restricted session mode, unavailable for all practical purposes. Does
> anyone have an idea how to speed up statement like:
>
> ALTER TABLE <tab> MERGE PARTITIONS A,B INTO PARTITION C UPDATE INDEXES?
>

If you turn on ( and then back off ) a 10046 trace what wait events are showing up?

Jonathan Lewis I think has some good info on practical ways of helping performance of merge partition. Tom Kyte also I believe. Received on Sat Dec 16 2006 - 18:42:13 CST