Re: goldengate table replication performance issue

Posted by Roshan on Jun 21, 2022; 10:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/goldengate-table-replication-performance-issue-tp10947p10961.html

By generating explain plan you mean enable the tracing and tkprof?

alter session set events '955 trace name errorstack level 10';
alter session set events '10046 trace name context forever, level 12';

Yes both source and target are same except I used KEYCOLS in replicat file
MAP CBS_CORE.CB_BILL_INV_ACC_LIST,TARGET CBSOGG.CB_BILL_INV_ACC_LIST,KEYCOLS(ACCOUNT_CODE_N, ACCOUNT_LINK_CODE_N, SUBSCRIBER_CODE_N, SUB_BATCH_ID_N, CHARGE_FROM_DATE_D, CHARGE_TILL_DATE_D, INVOICE_NUM_V) ;