Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

batch inserts from java

user4900730Oct 7 2009 — edited Oct 10 2009
We have used the 11g JDBC batch insert and have achieved insert rates of approx 7000 inserts per second in a sandbox environment.
We then tried populating a SQL table object and repeated the JDBC batch test but performance almost halved. Anybody know why?

We prefer to have a stored proc do the FORALL bulk inserts instead for more control of exception logging, row level exception logging etc.

What mechanism is the FASTEST (specific collection, nested table, temporary table, global temporary table etc) to pass the batch rows to a PL/SQL proc so it can bulk insert using FORALL?

Thanks in anticipation.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2009
Added on Oct 7 2009
4 comments
1,339 views