Oracle Golden Gate – Performance Toolkit Monitor

Applicable to Oracle Golden Gate version 12.1 and 12.2

Download ‘Oracle Golden Gate – Performance Toolkit Monitor’ – OGG - PTM 

While writing this post it's available on below URL.

Download: http://www.oracle.com/technetwork/middleware/goldengate/oracle-goldengate-exchange-3805527.html

Previously it was hosted on below URL and having OGGPTK.jar

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

To Enable OGG- PTM  - We must fulfill below pre-requisite.

In each of the GG Instance that you want to monitor, do the following in ggsci: 

      1. edit params ./GLOBALS

 add: ENABLEMONITORING

      2. create the datastore

 in ggsci: create datastore

Note: Using the ENABLEMONITORING parameter requires a license for the Golden Gate Management Pack. 

How to Launch:

Best thing is that, you don't need to logged-in to server to monitor the performance of OGG instance.

You can invoked as many as PTM session from your PC.

Open Command Prompt  (Considering that you have workstation on Windows OS)

• Run >> cmd 
• Check JAVA Version: java -version

    If JAVA is not installed then first download JDK and then try.

• java -jar \ogg-performancetoolkit-3810657.jar

Conection Name: As per your choice

Host : hostname or IP where OGG instance is running

Port  : OGG Manager Port (Check mgr.prm or ggsci > info mgr)

Click on 'Save'

Now go to File >> Connect - Now you can see the 'Connection Name' which you just have saved.

Click on that 'Connection Name'.

Please note, It shows all processes - including threads of 'coordinated' replicates. Here R_RA1*** and R_RA2*** are actually threads of co-ordinated replicates R_RA1 and R_RA2 respectively. 

Click on any process, will launch detail page on right side panel.

Process Performance

You can see below tabs on detail window

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

Thread Performance

Status and Configuration

Below you can see another three tabs - 

Log - Its ggserr.log

status - Stop/Start history of process

Files - Location of Configuration FIles

Trail Files

Cache Statistics

It gives the similar information while executing 'SEND EXTRACT group_name, CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL n}'

Database Statistics

Queue Statistics

Inflight Transactions

For Replication Process.

For Manager Process

You can change the Refresh Speed

You can explore this toolkit monitor and it has almost all required details to quickly reach to bottleneck in GG Setup if any.

Hope this is helpful..

We can also monitor through web browser and Curl - via RESTFUL web services URL 

FYI: Oracle Golden Gate version 12.3 Microservice Architecture is also based on REST API

Extended Monitoring Points - All Processes

http://xx.xxx.xxx.xx:7811/mpointsx

http://xx.xxx.xxx.xx:7811/groups

Click on Hyper Link