alter table shrink space
DB=10.2.0.3
The segment advisor is reporting a lot of tabels/indexes to be shrinked.
When I "select All" in Grid Control and take a look at the SQL it's like
alter table x1 enabel row movement;
alter table x1 shrink space;
alter table x2 enabel row movement;
alter table x2 shrink space;
and so on.
I executed it on the test node, and it took about 50% of the performance.
Would it speed up the reorg if I split the work into two or more jobs and execute them im parallel?
regards
Daniel