GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Intergrated extract is very slow but all logminer process is idle

edited Aug 14, 2020 5:43AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center