GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Storing GG Replicat Stats in a Table

edited May 15, 2019 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi All,

I have a requirement to store GG Replicate Stats to store in a Database Table for historical analysis.

like below

==========================

GGSCI (host1) 2> stats RX1

Sending STATS request to REPLICAT RX1 ...

Start of Statistics at 2019-04-26 09:39:30.

Replicating from SOURCE.TABLE1 to TARGET.TABLE1:

*** Total statistics since 2019-03-31 06:19:12 ***
        Total inserts                                 954594.00
        Total updates                                1844345.00
        Total deletes                                 955482.00
        Total discards                                     0.00
        Total operations                             3754421.00

========================================================================
Should be store in GGMONIT Table

REPLICATE_NAME  TABLE_NAME   INSERT_ROWS   UPDATE_ROWS   DELETE_ROWS   DISCARD_ROWS
==============  ==========   ===========   ===========   ============  =============
RX1               TABLE1 954594      1844345      955482             0

Is it possible via GG ?

BR//

Souvik

Tagged:

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