Intergrated extract is very slow but all logminer process is idle
goldengate version :12.3.0.1
oracle database version :12.2.0.1.0
hi,
I have three Intergrated extract. when I apply a psu (31305382) on my gi and database,and restart all.
my extract run very very slow .can not reduce the lag.
I found event on databse session like this:
INST_ID USERNAME PROGRAM STATUS ACTION EVENT P1 P2 BLOCKING_SESSION
------- ---------- ------------------------------------------- ----- --------------- ----------------------------------- ------------------------------ --------
1 SYS oracle@ (MS0A) ACTIVE OGG$CAP_EXTTT - Logminer Preparer LogMiner preparer: idle 44 0
1 GOLDENGATE extract@ (TNS V1-V3) ACTIVE OGG$CAP_EXTDZ - Capture LogMiner client: transaction 38 0
1 SYS oracle@ (MS09) ACTIVE OGG$CAP_EXTDZ - Logminer Builder LogMiner builder: idle 38 0