Table shrink taking long time
Hi,
DB-11.2.0.3. I was shrinking a fragmented table of 80 GB. It took 18 hrs, adding up both phases of shrink.
Why does the second phase taking such a long time when it has to adjust High watermark. The table is not busy either.
alter table application enable row movement;
Table altered.
Elapsed: 00:00:00.02
First phase
-----------
alter table application shrink space compact;
Table altered.
Elapsed: 09:38:30.04
Second phase
------------
alter table application shrink space;
Table altered.
Elapsed: 09:47:44.99
Regards
Raj
DB-11.2.0.3. I was shrinking a fragmented table of 80 GB. It took 18 hrs, adding up both phases of shrink.
Why does the second phase taking such a long time when it has to adjust High watermark. The table is not busy either.
alter table application enable row movement;
Table altered.
Elapsed: 00:00:00.02
First phase
-----------
alter table application shrink space compact;
Table altered.
Elapsed: 09:38:30.04
Second phase
------------
alter table application shrink space;
Table altered.
Elapsed: 09:47:44.99
Regards
Raj
0