Page 1 of 1
Oracle Connector - Oracle Bulk Load vs Insert
Posted: Mon Sep 25, 2017 9:00 am
by syedmuhammedmehdi
Hi, I'm loading 21 million records in a Oracle table and it is taking around 1 hr 30 Minutes to load using Oracle Connector. I used Bulk Load as well as Insert Mode in Oracle. Surprisingly, in both modes Bulk as well as Insert Mode job is taking same time to load. More surprisingly Bulk mode is taking more time. Could you please advise what might be wrong in bulk mode?
Posted: Mon Sep 25, 2017 9:45 am
by chulett
Are you certain it's actually performing a direct path bulk load? Without that specified and without meeting all requirements, sqlldr does conventional inserts.
Posted: Mon Oct 09, 2017 9:33 am
by syedmuhammedmehdi
Thanks Chulett for reply.Actually, after some debugging I came to know that there was no slowness caused by bulk load but before Oracle Connector I was using transformer in which I was calling Oracle Sequencer for surrogate key generator which was actually causing slowness. So, I removed surrogate key generation from transformer and used simple insert statement (without bulk load) in oracle connector with surrogate key next val.