title: Oracle slow inserts
body: <p>In my system, there is an loading process that insert some data to some table.</p>
  
  <p>(Oracle 11g)</p>
  
  <p>The etl tool generate the command :</p>
  
  <pre><code>INSERT INTO TEMP (v1, v2, v3, v4, v5, v6, v7, v8, v9)
      VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9);
  </code></pre>
  
  <p>(the fields are number and varchar2)</p>
  
  <p>The loading is about 40K rows.</p>
  
  <p>In the production the command take 25 minutes!</p>
  
  <p>It's about 23 rows per second.</p>
  
  <p>but when I'm trying to make the same load in the dev\test - it's realy fast.</p>
  
  <p>This table has 1 index and it exist in the dev too.</p>
  
  <p>The statistics of table\columns\index seems very similar in both prod and dev.</p>
  
  <p>I even try to import the prod statistics into the dev, but no change..</p>
  
  <p>any idea???</p>
  
  <p>Thanks.</p>