Database Administration (MOSC)

MOSC Banner

Segment advisor and alter table move partition

After looking at segment advisor findings we planned alter table move partition & rebuild indexes for several table partitions with local indexes

But after some a first run we stop

Segment advisor finding says:

Allocated 18GB Used 16GB Reclaimable 2GB

And after alter table move partition we have 18.2 GB for moved table partition

Move has been perform with no parallel run

Now we stopped to decide whether go on with other partition or not.

Why advisor finding was so wrong ?

Is there a recommended gain percentage to look at before deciding to move table partitions ?

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