row movement in Oracle

 Hello Experts !
   What is enable row movement in Oracle ?
    Where we can use this options in database ?
    What are the performance issues a DBA can face if it remains enabled on some frequently used  tables in database ?

Thnaks & regards
Who is Participating?
sdstuberConnect With a Mentor Commented:
just as it sounds,  "row movement" means the row can be physically moved from one area to another as part of updates.  That is,  the data may be deleted from one data file and rewritten to another part of the datafile, or a new datafile, or even a new tablespace entirely in some cases.

Partitioning is probably the most common use of this feature.
For example,

I have data partitioned by year and each year-partition is in its own tablespace.

Now, I update a row that was for 2009 to be 2010.  It must go into a new partition, but the only way it can do that is if the table allows row movement because the update requires a physical rearrangement, not just twiddling some bytes.

Row movement is a performance drag when it happens but if it's necessary then it's necessary.

if the data changes never require row movement then having it enabled won't incurr a performance penalty.
Shaju KumbalathDeputy General Manager - ITCommented:
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

if you enable row movement for the purposes of reorganization, as in the link above.  I suggest you enable, do the reorg and then disable.

But first, be sure the reorg is necessary.
schwertnerConnect With a Mentor Commented:
The positive sides of row movements are explained   by the previous postings and also here :

But there are also negative movements called row migration. This means that there is not enough space in the Oracle Data Block (by update operation) for the record and Oracle has placed the record in otherOracle block. But this slows down the processing and should be avoided.

Sometimes Oracle blocks get fragmented on the disk device. In this case some techniques (export/import or tablespace change) can help to improve the placement.
slightwv (䄆 Netminder) Commented:
These questions sound a lot like homework/exam questions.
@ slightwv:

Row Movement is not part even of Oracle University DBA Courses.
So (if you are right) this should be a very sophisticated course in a technological University

@ junaid_baig1: please clarify, because slightwv has the power to close the tread (I not :) )
junaid_baig1Author Commented:

 Thanks !!
 we faced this Issues as new Year begins!

@schwertner:  Thanks!! I think slightwv couldn't get point..
junaid_baig1Author Commented:

 @slightwv:  i think you didn't get the point that i raised!  This is quite a common Issue that Development DBA team faced every now & than & They 've discussed the Issue with US  ! 'm DBA ADMIn !    

Thanks & regards
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.