My Oracle Support Banner

Using Golden Gate View GV$GOLDENGATE_TABLE_STATS In SQL Scripts To Generate Custom Reports (Doc ID 2404482.1)

Last updated on FEBRUARY 10, 2020

Applies to:

Oracle GoldenGate - Version 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!

In this Document

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