Using Golden Gate View GV$GOLDENGATE_TABLE_STATS In SQL Scripts To Generate Custom Reports

(Doc ID 2404482.1)

Last updated on MAY 30, 2018

Applies to:

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

Goal

Customer wanted to use the VIEW GV$GOLDENGATE_TABLE_STATS to create some custom reports, which would run at DB level ie. SQL scripts & would generate reports on the OGG processes configured. The Custom SQL script would query the view every hour and use the DELTA between 2 subsequent runs as an indication for the number of processed records per hour. This same VIEW is also used in Oracle's Golden Gate health check script.

 

Solution

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