title: ORA-00060: deadlock detected while waiting for resource
body: <p>I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These scripts are written by somebody else and are meant to be executed concurrently. All the scripts are performing updates on a table. I am getting the error,</p>
  
  <blockquote>
    <p>ORA-00060: deadlock detected while
    waiting for resource</p>
  </blockquote>
  
  <p>As I googled for this, I found,
  <a href="http://www.dba-oracle.com/t_deadly_perpetual_embrace_locks.htm" rel="noreferrer">http://www.dba-oracle.com/t_deadly_perpetual_embrace_locks.htm</a></p>
  
  <p>Even though the scripts are performing updation on the same table concurrently, they are performing updates on different records of the table determined by the <code>WHERE</code> clause with no overlaps of records between them. </p>
  
  <p>So would this have caused the error?.</p>
  
  <p>Will this error happen regardless of where the updates are performed on a table?.</p>
  
  <p>Should I avoid concurrent updates on a table at all times?.</p>
  
  <p>Strangely I also found on the nohup.out log,
  <code>PL/SQL successfully completed</code> after the above quoted error.</p>
  
  <p>Does this mean that oracle has recovered from the deadlock and completed the updates successfully or Should I rerun those scripts serially?
  Any help would be welcome.</p>
  
  <p>Thanks in advance.</p>