title: How often to I commit in Oracle
body: <p>I am deleting a large amount of data from the a large Oracle database. The process I have followed is that I delete a record table A with causes CASCADE delete on table B which has CASCADE delete on some other table. So basically there are several tables related with each other with CASCADE delete. </p>
  
  <p>Currently this process works in iteration for a number of records in table A and I only COMMIT at the very end of the iteration (when all data is deleted). The process takes around 30 hours to complete. </p>
  
  <p>I have been suggested to have regular COMMIT, i.e. a COMMIT for each record deletion for table A (including deletion on any subsequent records in child tables).</p>
  
  <p>I know that regular commit will keep the undo log size low but is there any performance improvement with regular commits? Would I see an improvement in the time it takes to complete the script?</p>