Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/starsolu/ on line 663

Warning: Creating default object from empty value in /home/starsolu/ on line 29

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/starsolu/ on line 13
Oracle GoldenGate 12.2 New Feature - Performance Toolkit Monitor - ORACLE-SCN

Oracle GoldenGate 12.2 New Feature – Performance Toolkit Monitor

By December 15, 2016 5 Comments

One of the features which I like most and released in Oracle GoldenGate 12.2 is the Oracle GoldenGate Performance Toolkit Monitor. This is a monitoring tool with Graphical User Interface programmed in JAVA.

The Performance Toolkit Monitor provides new metrics for diagnostics and tuning which includes the below.,:

Transactions in flight
Cache memory usage and statistics
Improved capture and apply performance

A simple jar file “OGGPTK.jar” needs to be run in the server to invoke this Performance Monitor tool. This free java program jar file can be downloaded from the below link,

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

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

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

I had downloaded and copied the OGGPTK.jar file in the J:\OGGPTK.jar, This is my host machine where I had installed Virtual Box and have two Virtual Machines as mentioned above. The two virtual machines are already started and all the Oracle GoldenGate processes like Extract, Pump and Replicat are running currently.



Firstly, I need to start the OGGPTK.jar using the java command as below,



Oracle GoldenGate Performance Tool Kit window will be opened.


To monitor the GoldenGate instance, connection configuration must be done as below.,



Hostname of the Oracle GoldenGate instance and the Port of the Manager process running in that respective instance must be given as below. Save the configuration.



I have already configured the connection for my OGG instances. To start monitoring the Oracle GoldenGate instances go to File–>Connect–>Click the Connection Name


I have selected my Source OGG instance and the Monitoring windows for that instance will be opened as below. Click on any Process in the Left pane. For example Extract Process,


The below information can be seen in the OGGPTK window,

Process Performance
Thread Performance
Status and Configuration
Trail Files
Cache Statistics
Database Statistics
Queue Statistics
Inflight Transactions

Let us see what information each tab gives us.,

Thread Performance


Status and Configuration


Trail Files


Cache Statistics


Database Statistics


Queue Statistics


Inflight Transactions


The same kind of information we can see for the other Oracle GoldenGate processes in the instances too..

Hope this is helpful..!! Your comments and suggestions are always welcome. Thanks for your continuous support 🙂


Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!