title: Oracle insert performs too long
body: <p>I'm confused about time Oracle 10g XE performs insert. I implemented bulk insert from xml file into several tables with programmatical transaction managment. Why one insert performs in a moment and another more than 10 minutes! I can't wait more and stop it. I think there's something more complex I have not payed attention yet.</p>
  
  <p>Update:</p>
  
  <p>I found lock using Monitor.</p>
  
  <pre><code>Waits     
  Event   enq: TX - row lock contention
  name|mode   1415053316
  usnusnusnusn&lt;&lt;16 | slot 327711
  sequence    162
  
  SQL   
  INSERT INTO ESKD$SERVICESET (ID, TOUR_ID, CURRENCY_ID) VALUES (9, 9, 1)
  </code></pre>
  
  <p>What does it mean and how should I resolve it?</p>