Oracle EXCHANGE PARTITION slow
Oracle 11.2.0.4. EE. AIX 7.1
We implement a procedure to exchange partition for a big table. move historical information. the procedure have three Main table , stage table and historical table. We exchange partition ffom main table to stage table , then exchange the stage table with historical table, but the issues is the process spend almots 20" and is increasing, the partition is bewteen 1MM to 5 MM of rows ( becasuse is inteval by month , every month is increased).
What could be the reason and how can improve ?