title: What is the difference between giving BatchSize and not giving BatchSize for OracleBulkCopy
body: <p>Can anybody give the performance &amp; behavior difference between using <a href="http://docs.oracle.com/html/E10927_01/OracleBulkCopyClass.htm#CHDCDEIA" rel="nofollow"><code>BatchSize</code></a> and without using <code>BatchSize</code> in <a href="http://docs.oracle.com/html/E10927_01/OracleBulkCopyClass.htm" rel="nofollow"><code>OracleBulkCopy</code></a>. Currently I don't specify <code>BatchSize</code>. My <code>BatchSize</code> may vary from 100 to 200000. Please suggest the best approach.</p>
  
  <pre><code>try
  {
       var columnMapping =
           from table in orgTable.Columns.Cast&lt;DataColumn&gt;()
           select
               new OracleBulkCopyColumnMapping(table.ColumnName, table.ColumnName);
       using (var bulkcopy
           = new OracleBulkCopy(ConnectionString, OracleBulkCopyOptions.Default))
       {                    
           bulkcopy.DestinationTableName = GoldOrgTable;                                        
           foreach (var mapping in columnMapping)
               bulkcopy.ColumnMappings.Add(mapping);
           bulkcopy.BulkCopyTimeout = TimeOut.Value;
           bulkcopy.WriteToServer(orgTable);
           orgTable.Dispose();
       }
       return true;
  }
  </code></pre>