SQL Performance (MOSC)

MOSC Banner

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 ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center