title: What are the consequences/side effects of deleting STALE records from Oracle DB with Large Data?
body: <p>This may sound like a silly questions. 
  However, one of the easiest solutions to keep my data consistent is to delete <strong>STALE</strong> records from my DB Table. My table has millions of row. </p>
  
  <p>Can anyone please tell me consequences/side-effects of deleting data from DB.</p>
  
  <p>This DB will be heavy read and medium writes. </p>
  
  <p>Any predictions or 2 cents here before I learn it the hard way on the production website? Will thereby unwanted side-effects caused by inserts &amp; deletes? </p>
  
  <p><strong>[UPDATE]</strong></p>
  
  <ol>
  <li><p>One of the plausible solutions I have in mind is:
  I have always have options of adding another column to determine if the data is stale or not. However, with this solution, I need to keep track of another variable.</p></li>
  <li><p>An event is fired which indicates that a single row in the Table is stale. We plan to delete the row when the event is fired.</p></li>
  </ol>