Running downstream integrated extract. Found big lag with extract, logminer builder CPU is almost 100% busy and memory consumption is huge (16g). Any ideas how to deal with this? on the source side, they are many transactions going on.
here is in the downstream logmining server (GG 12.1 and Oracle 11.2.0.4) Thank you.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
56014 oracle 20 0 32.3g 16g 16g R 99.5 2.2 255:24.52 oracle
ps -ef|grep 56014
oracle 56014 1 36 Jul26 ? 04:15:46 ora_ms01_PLI05M2
PATH 1 RUN_ID 1 RUN_TIME 2017-JUL-26 22:10:16 CCA Y
|<C> OGG$CAP_RE05I 1215 1097 -1 LMR 0% 95.3% 3% "" LMP (4) 340.3% 0% 57.3% "enq: MN - contention"
LMB 10.3% 0% 88% "CPU + Wait for CPU" CAP 98.7% 0% 1.3% "" |<Q> "GGS_OWNER"."OGG$Q_RE05I" 0.01 0.01
0 |<A> OGG$RE05I 0.01 0.01 0 |<B> NO BOTTLENECK IDENTIFIED