title: What is the impact of enabling/disabling ROW_MOVEMENT in Oracle 10g?
body: <p>We are using oracle 10G and one of the table takes lot of time if we query/delete data. This table contains around 10 million records.</p>
  
  <p>Recently we discovered that ROW_MOVEMENT is disabled on this table, we want to understand following:</p>
  
  <ol>
  <li>What performance gain we can get if enable ROW_MOVEMENT ?</li>
  <li>Are there any downsides of enabling ROW_MOVEMENT ?</li>
  <li>What trigger's row movement ? How does oracle decides it needs to move ROWS ?</li>
  </ol>
  
  <p>Any help would be highly appreciated.</p>
  
  <p>Thanks in advance !!</p>