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!

BLOB column inserts are slow

Sreekeshava SDec 19 2012 — edited Dec 24 2012

Hi All,

Have a table with 7 columns where 4 columns are of Varchar2 type, 2 columns are of NUMBER type and 1 column is of type BLOB.

Myself inserting the values to the table from JAVA program. Insertion to VARCHAR2 and NUMBER type columns are very much fast. But insertion to BLOB column is dead slow(data to BLOB column values are about 10KB).

Please help me in this regard to insert BLOB values fastly.

Regards/Sreekeshava S

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 21 2013

Added on Dec 19 2012

#blob

11 comments

1,404 views