Skip to main content
GoldenGate

Oracle GoldenGate 12.2 New Feature – New GoldenGate Extended Metrics

By November 20, 2016No Comments

Oracle GoldenGate Extended Metrics provides the real-time insight of the Oracle GoldenGate processes Extract, Extract Pump and Replicat. This can be accessed through the RESTful Web Interface.

The New Metrics provides the below information,

Status and Configuration Information

Process and Thread Level Metrics for Extract, Pump and Replicat

Database Statistics for Extract and Replicat & Network Statistics for Pump

In-flight transactions and queue statistics for Extract

Table statistics for Replicat

This is a fine grained performance monitoring window which can be accessed through the RESTful Web Services as below,

extmetrics5

I have two Virtual Machines installed with Oracle GoldenGate 12.2.x

Virtual Machine 1 - OGGR2-1 - 192.168.0.10 - Manager, Extract and Extract Pump

Virtual Machine 2 - OGGR2-2 - 192.168.0.11 - Manager and Replicat

Below is how the information is displayed.,

General and Status information of the Extract process EXT1

Configuration information of the Extract process

Database information where the Extract Process EXT1 is running

Trail File information of the Extract process EXT1

Position, Lag and Checkpoint information of the Extract process EXT1

Performance information of the Extract process EXT1

extmetrics

extmetrics2

extmetrics3

Similar information can be seen for the Replicat process also which is running in the other virtual machine

extmetrics4

This is an excellent tool to monitor the progress and performance of the Oracle GoldenGate processes.

Leave a Reply