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 22.214.171.124.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!