Using Golden Gate View GV$GOLDENGATE_TABLE_STATS In SQL Scripts To Generate Custom Reports
Last updated on MAY 30, 2018
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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