My Oracle Support Banner

GoldenGate STATS Command On Replicat Returns 'No database operations have been performed' (Doc ID 2539747.1)

Last updated on DECEMBER 12, 2019

Applies to:

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

Symptoms

In Goldengate 12.3, STATS command output was showing as below but replication was actually working well i.e. data was replicating without any issue between source and target. Stats command on extract and pump process was working without any issue.

GGSCI3> stats <replicat_name> totalsonly *.* reportrate min
Sending STATS request to REPLICAT <replicat_name>...
Start of Statistics at 2019-05-01 17:03:39.
Integrated Replicat Statistics:

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

Cumulative totals for specified table(s):


*** Total statistics since 2019-04-29 10:53:11 ***
       No database operations have been performed.

*** Daily statistics since 2019-05-01 00:00:00 ***
       No database operations have been performed.


*** Hourly statistics since 2019-05-01 17:00:00 ***
       No database operations have been performed.


*** Latest statistics since 2019-04-29 10:53:11 ***
       No database operations have been performed.

End of Statistics.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.