Currently , General tables which are does not have CLOB column , Loading speed is good ( 10~ 30 million records per min) network is 10GB and CDC Server spec. is 40 Physical core (80 logical core) , Zeon gold 6230 2.1GHz , 256 GB memeory , SSD Storage. When I clob limit change to below 8K , it is not bed more than 50 thousand . Also I use parallel loading option in table setting. (780 segments, 20 maxmum number of tables in task setting.
I cannot change parameters (directPathColumnArrayRows and directPathStreamSize ) ,when I change those, I met error.
Yesterday , I tested a table , max clob size is 30MB and lob column size is bigger than 8K, loding result is 42,344,550 records 743,535 MB 12:46:58 duration. it is 10 % of full table size. Fortunately , snap shot too old error is not occurred.