title: Multiple process accessing single table for insert
body: <p>I have a TABLE (PROCESSED_RECS) which is accessed by multiple processes (around 60). All of them insert recs in this file. </p>
  
  <p>Purpose:</p>
  
  <ul>
  <li>Processes take an input file of keys to process</li>
  <li>they check if keys is already process - i.e. in table PROCESSED_RECS</li>
  <li>To check, processes just fire INSERT query</li>
  <li>if they get DUPLICATE ERROR freom Oracle, they get to know it is already processed.</li>
  </ul>
  
  <p>But i am getting error</p>
  
  <blockquote>
    <p>ORA-00060: deadlock detected while waiting for resource</p>
  </blockquote>
  
  <p>What is the best practice for achieving above scenario ?</p>
  
  <p>I am using <code>PRO C</code> with <code>C</code> language</p>