Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER TABLE SHRINK SPACE COMPACT takes long time

R. RoyalJan 21 2016 — edited Jan 27 2016

Hi,
I run:
ALTER TABLE TOM.TAB1 SHRINK SPACE COMPACT;
ALTER TABLE TOM.TAB1 SHRINK SPACE CASCADE;


The "ALTER TABLE TOM.TAB1 SHRINK SPACE COMPACT" was completed in 2 hours, but "ALTER TABLE TOM.TAB1 SHRINK SPACE CASCADE" is still running after 8 hours, below the size of the table TAB1 and indexes:

SEGMENT_NAME...............GB
TAB1.................................166
IDX01................................83
SYS_C00.........................42
IDX02.............................142
IDX03..............................66
IDX04.............................122


Why "SHRINK SPACE COMPACT" takes long time?
Is there any way to check how much time does it take?

Thanks in advance!

This post has been answered by Dear DBA Frank on Jan 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2016
Added on Jan 21 2016
15 comments
9,611 views