Monitor performance using the OCI GoldenGate deployment console

Learn to use the reports and Performance Metrics service in the OCI GoldenGate deployment console to monitor the deployment’s health and performance.

Note: This information applies only to Data replication deployments.

Monitoring Oracle GoldenGate Service Performance

You can monitor the performance of GoldenGate processes within the OCI GoldenGate deployment console using the Performance Metrics Service. The metrics service collects and stores instance deployment performance results.

After you log in to the OCI GoldenGate Deployment Console, select Performance Metrics Service. All the OCI GoldenGate processes are shown in their current state. Select a process to view its performance metrics.

Each service provides an elaborate view of the processes, threads, trail files, database configuration, and so on, depending on the service that you are viewing. The page also provides the option to Pause or Clear the data displayed on the page. To get a snapshot of the trends captured for each of the services, see the following table:

   
Metrics Report Tab Available with Service
Process Performance

  • Administration Service

  • Distribution Service

  • Performance Metrics Service

  • Receiver Service

  • Extracts

  • Replicats
Thread Performance

  • Administration Service

  • Distribution Service

  • Performance Metrics Service

  • Receiver Service

  • Extracts

  • Replicats
Status and Configuration

  • Administration Service

  • Distribution Service

  • Performance Metrics Service

  • Receiver Service

  • Extracts

  • Replicats
Server Statistics

  • Distribution Service

  • Performance Metrics Service
Trail Files

  • Extracts

  • Replicats
Database Statistics

  • Extracts

  • Replicats
Procedure Statistics

  • Extracts

  • Replicats
Cache Statistics Extracts
Queue Statistics Extracts

Reviewing Messages

Messages from the services are displayed in Performance Metrics Service home page.

To review the messages sent or received, do the following:

  1. In the OCI GoldenGate Deployment Console, select Performance Metrics Service.

    The Performance Metrics Service Overview page is displayed.

  2. Select the Messages Overview tab (if it’s not already selected) to see a drill down into all the service messages.

    Scroll through the list of messages or search for a specific message by entering the text in the message.

  3. Select Refresh to get a synchronized real-time list of messages before you start searching. You can also change the page size to view more or fewer messages.

Review Status Changes

Real-time status changes to services can be monitored from the Performance Metrics Service Status Changes Overview tab.

Status change messages show the date, process name, and its status, which could be running, starting, stopped, or killed.

To view status changes, select Performance Metrics Service from the OCI GoldenGate Deployment Console home page, and then select the Status Changes Overview tab. A list of status change messages from the service appears.

If you are searching for specific messages, you can use the search but make sure you select Refresh before you search to ensure that you get the updated status for services.

Note that the search messages appear in different colors to differentiate critical and informational messages.