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!

Option for Bulk insert from Java

littleboyAug 17 2011 — edited Aug 17 2011

Hi ,

I have a log table which records every stage of processing of a batch. Unfortunately this takes hell lot of time and nearly 20-25% of total time is spent on inserting records in to this table. Batch has a java call (thru DAO's -- I am not much familiar with Java) from where the record is inserted.

In order to tune this, can we have an object type and insert into it and at the end of execution use bulk insert to insert into table ??? -- Will this improve performance ? Or is there any other way out ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2011

Added on Aug 17 2011

2 comments

1,669 views