title: Performance optimization for processing of 115 million records for inserting into Oracle
body: <p>I have a requirement where I am reading a text file placed in Unix of size 19 GB and having records around 115 million. My Spring Batch (Launcher) is getting triggered by Autosys and Shell script once the file is placed in the location.</p>
  
  <p>Initially on execution of this process it took around 72hrs to read, process(Null checks and date parsing) and write the data into the Oracle database.</p>
  
  <p>But after certain configuration changes like using Throttle Limit, Task Executor etc, I was able to reduce execution time to 28hrs currently.
  I need this process to be complete in 4hrs,also, using SQL loader separately I am getting the work done in 35 minutes. But I have to using spring Batch only.</p>
  
  <p>Can anyone tell me if it is possible to get it done in less than 4 hours using spring batch and what can be the best way to achieve that?</p>