if commit interval is set to high value, performance will be high. if commit is given for every 1000 rows say for eg,it will affect the performance badly
if you have increased your commit interval to ~25000 rows the session will run faster but when your session fails at 24000th record you will not have any data in your target.
When you decrease your commit interval to ~10000 rows your session will be slow when compared to previous but if the session fails at 24000th record you will lose only 4000
records
