OGG v12.1.2.x do not generate stats correctly for IR

(Doc ID 2224896.1)

Last updated on JANUARY 24, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 and later
Information in this document applies to any platform.

Symptoms

Even though the IR replicate the data correctly to the target database, the
stats is been shown incorrectly

------
GGSCI (cehaovmsp1099) 6> stats pjrep

Sending STATS request to REPLICAT PJREP ...

Start of Statistics at 2016-12-09 09:36:03.

Integrated Replicat Statistics:

Total transactions 3393.00
Redirected 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%

Replicating from FALCON.CS_CASE to PJACOB.CS_CASE:

*** Total statistics since 2016-12-09 09:29:51 ***

No database operations have been performed.

*** Daily statistics since 2016-12-09 09:29:51 ***

No database operations have been performed.

*** Hourly statistics since 2016-12-09 09:29:51 ***

No database operations have been performed.

*** Latest statistics since 2016-12-09 09:29:51 ***

No database operations have been performed.

End of Statistics.
--------

SQL> select count(*) from pjacob.cs_case;

COUNT(*)
----------
3393
---

GGSCI (cehaovmsp1099) 4> send pjrep, status

Sending STATUS request to REPLICAT PJREP ...
Current status: At EOF
Sequence #: 106
RBA: 25730270
0 records in current transaction
--------------------------------------------------------

The ogg v12.2.x shows the statistics correctly.
The issue happens only with ogg v12.1.2.1.12 and above.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms