Dear OGG experts,
Source DB version : 11.2.0.4 (OGG version - 18.1)
Target DB version : 19.8 (OGG version - 19.1)
The replicat lag is never coming down. It is in "RUNNING" status all the time and progressing, but never fully catching up the volume.
Can you please suggest what's causing the LAG and how this may be resolved ?
replicat parameter file below:
========================
replicat RSTOT211
DiscardFile ./dirrpt/RSTOT211.dsc, Purge, megabytes 1024
-- TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 1536)
useridalias WSTP0
include ./dirmac/ST_wST_ot2_maclib.mac
--assumetargetdefs
-- DYNAMICRESOLUTION
-- REPERROR (01403, DISCARD)
-- 00001 unique constraint voilated
-- 01403 no data found
-- REPERROR (-1, DISCARD)
-- REPERROR (0001, DISCARD)
-- REPERROR (-1403, DISCARD)
-- REPERROR (01403, DISCARD)
--- These 3 parameters added to improve replicat performance
DBOPTIONS INTEGRATEDPARAMS(EAGER_SIZE 100000)
-- DBOPTIONS INTEGRATEDPARAMS(batcSTql_mode sequential)
DBOPTIONS INTEGRATEDPARAMS (max_sga_size 2048, parallelism 4)
-- Use BATCHESPERQUEUE in warehouse type of loads
-- BATCSTQL BATCHESPERQUEUE 1000
BATCSTQL BATCHESPERQUEUE 1000,BATCHTRANSOPS 100000, OPSPERBATCH 100000,OPSPERQUEUE 5000
Map ODS.O_IE_SHIPS, Target SEA_CDC.O_IE_SHIPS, #mac_cols24();