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!

Impact of permenantly enabling row movement

SM_308Aug 25 2016 — edited Aug 25 2016

RDBMS version: 11.2.0.4

OS : Oracle Linux 6.4

For a particular batch job I have noticed that running ALTER TABLE SHRINK on two large tables before the activity improves the performance .

Every week I run this batch job. Now, I don't bother to disable the row movement after the activity.

So, is it fine to permenantly enabling row movement ? The tables are around 200GB each.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2016

Added on Aug 25 2016

#general-database-discussions

6 comments

579 views