8 Monitoring Performance

Observe and maintain the health of your OCI GoldenGate resources by regularly monitoring metrics, creating alarms, and subscribing to events to keep informed of any abnormal activity among your resources. You can view peformance metrics in both the Oracle Cloud Console and the OCI GoldenGate deployment console.

Metrics

In the Oracle Cloud console, you can view metrics on the Deployment Details page and the Metrics Explorer. You can also create Alarms to stay informed of certain events and take action when needed.

Note:

Ensure that you upgrade your deployment to the latest version to leverage all available metrics.

You can view the following OCI GoldenGate metrics in the Oracle Cloud console on the Deployment Details page and the Metrics Explorer:

  • CPU Utilization: The aggregate of all Oracle Compute Units (OCPUs).
  • CPU Consumption: The aggregate number of OCPUs consumed.
  • Memory Utilization: The percentage of aggregate memory. Each OCPUs allocates 16 GB memory.
  • Deployment Overall Health: The health score of the deployment, which is the aggregate health of the deployment's processes (Administration, Distribution, Receiver, and Performance Metric Services)
  • Deployment Inbound Lag: Lag captured for Extracts designated as critical. This metric is the aggregate of all Extracts in the deployment.
  • Deployment Outbound Lag: Lag captured for Replicats designated as critical. This metric is the aggregate of all Replicats in the deployment.
  • Swap Space Usage: Amount of swap space, in gigabytes, used by the deployment
  • Temp Space Usage: Amount of temporary space, in gigabytes, used by the deployment
  • File System Usage: Amount of file system space, in gigabytes, used by the deployment
  • Extract Status: Health percentage of an Extract process in the deployment.
  • Replicat Status: Health percentage of a Replicat process in the deployment.
  • DistributionPathStatus: Health percentage of a Distribution Path process in the deployment.
  • ReceiverPathStatus: Health percentage of a Receiver Path process in the deployment.
  • ExtractLag: Average lag, in seconds, of a Extract process in the development.
  • ReplicatLag: Average lag, in seconds, of a Replicat process in the development.
  • DistributionPathLag: Average lag, in seconds, of a Distribution Path process in the development.
  • ReceiverPathLag: Average lag, in seconds, of a Receiver Path process in the development.

Note:

You'll only see metrics for the processes used in your deployment. For example, if you only have an Extract and Replicat, then you won't see Distribution or Receiver Path metrics.

To learn more about about these metrics, see the Oracle Cloud Infrastructure GoldenGate Metrics reference and using Metrics to troubleshoot.

Learn more about the Oracle Cloud Monitoring.

Alarms

For each metric on the Deployment Details page, you can create an alert to inform you when a condition is met. For example, you can create an alarm to notify you when OCPU consumption is less than 50%.

To create an alarm:
  1. From the Options dropdown of a metric chart, select Create an Alarm on this Query.
  2. On the Create Alarm page, under Define Alarm, add the trigger.
  3. For Alarm Settings, complete the following fields as needed:
    • Alarm Name: Enter the name that serves as the title for notifications related to this alarm. Avoid entering confidential information.
    • Alarm Severity: Select the perceived type of response required when the alarm is in the firing state.
    • Alarm Body: Enter the content of the notification to deliver.
    • Tags (optional): Select or enter free-form tags to apply to this resource.
    • Metric description: The metric to evaluate for the alarm condition.
      • Compartment: Select the compartment that contains the resources that emit the metrics evaluated by the alarm. The selected compartment is also where the alarm is stored.
      • Metric Namespace: Enter the service or application emitting metrics for the resources that you want to monitor.
      • Resource Group (optional): Select the group that the metric belongs to.
      • Metric Name: Enter the name of the metric. Only one metric can be specified.
      • Interval: Select the aggregation window, or the frequency at which data points are aggregated.
      • Statistic: Select the aggregate function.
  4. Confirm the values for Metric dimensions. Optionally, click + Additional dimension to add another dimension to the alarm.
  5. For Trigger rule, complete the Operator, Value, and Trigger delay minutes fields. The graph displays the boundaries for which the alarm triggers a notification.
  6. For Notifications, complete the fields as needed:
    • For Destination service, select Notifications Service.
    • For Compartment, select the compartment to store the topic used for this notification.
    • For Topic, click Create topic to set up a topic and subscription protocol in the designated compartment using the designated Destination service.
    • (Optional) Click + Additional destination service to add another destination service.
    • (Optional) Enable Repeat Notification and select Notification Interval if you want the alarm to resend notifications at the specified intervals when the alarm is in the firing state.
    • (Optional) Enable Suppress Notifications to specify a window of time to suspend evaluations and notifications. This is useful for maintenance periods.
  7. Click Save alarm.

For more information, see Viewing Default Metric Charts.

Subscribe to Events

Events are structured messages that indicate changes in resources. Subscribing to OCI GoldenGate events enable you to keep informed of abnormal activity among your OCI GoldenGate resources, as well as when your deployment reaches its storage limit and when an upgrade is available.

Create rules to subscribe to these events and trigger actions. For example, a rule might specify goldengate.stateneedsattention triggers the Notifications service to send an email to your systems administrator.

For more information, see:

About the Performance Metrics Service Home Page

The Performance Metrics Service uses the metrics service to collect and store instance deployment performance results. The Performance Metrics Service home page allows you to perform these tasks.

When you arrive at the Performance Metrics Service home page, you see all the OCI GoldenGate processes in their current state. You can click a process to view its performance metrics. You can also access service messages and status change details from this page.

Here’s a general overview of the tasks that you can perform from this page.

Task Description

Review Messages

Reviewing Messages from the Messages Overview tab.

Review Status Changes

Click the Review Status Changes tab to review changes in status of a service.

Monitoring Oracle GoldenGate Service Performance

You can drilldown to trend monitoring and statistical analysis of data for all OCI GoldenGate services and processes. The Performance Metrics Service offers these detailed views with graphical representations of statistical data in real-time.

The Performance Metrics Service home page presents a dashboard view of all the services, along with their statuses. Click on a service to view reports for that particular service.

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, click Performance Metrics Service.
    The Performance Metrics Service Overview page is displayed.
  2. Click 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. Click 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, click Performance Metrics Service from the OCI GoldenGate Deployment Console home page, and then click 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 click 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.