Oracle GoldenGate 12.2 New Feature – Performance Toolkit Monitor

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.,:

CPU
I/O
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,

https://java.net/projects/oracledi/downloads/download/GoldenGate/OGGPTK.jar

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

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.

picture1

picture2

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

picture3

picture4

Oracle GoldenGate Performance Tool Kit window will be opened.

picture5

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

picture6

picture7

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.

picture8

picture9

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

picture10

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,

picture11

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

picture12

Status and Configuration

picture13

Trail Files

picture14

Cache Statistics

picture15

Database Statistics

picture16

Queue Statistics

picture17

Inflight Transactions

picture18

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 🙂

You may also like...

5 Responses

  1. Oraboy says:

    Find this extremely informative and helpful.

    Thanks much for the share.

  2. Abdellatif Abugharbieh says:

    Can you please upload OGGPTK.jar to different url or send it to my email: abed81@hotmail.com
    Thanks

  3. Prajwal Gowda says:

    Hi, Many thanks for the information, Very useful,
    Jar file is not available in below link, seems like java.net is no more, If possible can you please provide any alternative link.
    https://java.net/projects/oracledi/downloads/download/GoldenGate/OGGPTK.jar

    Thanks,

    Prajwal

Leave a Reply

Your email address will not be published. Required fields are marked *