GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Why is extract takeing too long for a check point to apply

edited Jul 16, 2019 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

Why is my time since chkpt value keep increasing. Any help.

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     DP_P200     00:00:00      22:02:33

EXTRACT     RUNNING     DP_P300     00:00:00      25:58:28

EXTRACT     RUNNING     DP_P400     00:00:00      00:00:03

EXTRACT     RUNNING     DP_P500     00:00:00      00:00:03

EXTRACT     RUNNING     DP_P600     00:00:34      00:00:09

EXTRACT     RUNNING     EXT_P200    19:53:22      22:02:34

EXTRACT     RUNNING     EXT_P300    00:00:03      25:58:32

EXTRACT     RUNNING     EXT_P400    00:00:54      00:00:04

EXTRACT     RUNNING     EXT_P500    00:00:50      00:00:06

EXTRACT     RUNNING     EXT_P600    00:00:57      00:00:06

REPLICAT    RUNNING     REP_1000    00:00:00      00:00:07

My source DB is a warehouse and also target for GG, GG version is 12.2, DB is 12.1

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