This discussion is archived
0 Replies Latest reply: Mar 5, 2012 6:38 AM by chuongnh RSS

How to speed up intial load for LOB table

chuongnh Newbie
Currently Being Moderated
Dear OGG guys,

I have table get about 2 million records which content LOB (customer picture). Now, i am using intial load the table to other one. I configure OGG which have 1 intial load capture process, 1 datapump and 2 replicat.

But the loading speed is too slow (about 20-30 record per second). By the way, i do research on OGG doc, and found a BULKLOAD parameter for replicat on Reference guide.
But i am still not clearly understandy about this parameter. Do it make the replicat faster ?

So, have you guy get any experience about this synchronous for lob table like me now ? please give me a advise for this ?

So thanks and best regards
Ch

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points