Note:

This tutorial requires access to Oracle Cloud. To sign up for a free account, see Get started with Oracle Cloud Infrastructure Free Tier.
It uses example values for Oracle Cloud Infrastructure credentials, tenancy, and compartments. When completing your lab, substitute these values with ones specific to your cloud environment.

Monitor Oracle Database@Google Cloud using Google Cloud Monitoring

Introduction

Google Cloud Monitoring lets you monitor your Oracle Database@Google Cloud resources using custom dashboards. You can create custom dashboards using Google Cloud Monitoring and the available Oracle Database@Google Cloud metrics and logs.

This tutorial walks you through the tasks to view and use the monitoring metrics available for Oracle Database@Google Cloud resources using Google Cloud Monitoring.

You can use Google Cloud Monitoring to monitor your Oracle Database@Google Cloud resources using custom dashboards, and metrics charts and alerts.

Objectives

As a database admin or user:

Monitor Oracle Database@Google using Google Cloud Monitoring.
Create a custom monitoring dashboard for Oracle Database@Google Cloud.

Prerequisites

Access to a pre-provisioned Oracle Autonomous Database instance in Oracle Database@Google Cloud.

Task 1: View Available Metrics in Google Cloud

You can view available Oracle Database@Google Cloud metrics using Google Cloud Monitoring in the Google Cloud console.

Log in to the Google Cloud Console, enter Metrics explorer in the search bar and click Metrics explorer.
Go to the Queries section, click Select a metric drop-down menu and select Autonomous Database. Click ACTIVE METRIC CATEGORIES drop-down menu and select Autonomousdatabase. Click ACTIVE METRICS drop-down menu and select CPU Utilization.
Click Apply. The metric is displayed. You can view your metric as a chart, table, or both by selecting the option in the results pane.

Similarly a number of other metrics can be viewed for autonomous database.

Task 2: Create a Custom Dashboard and Monitor using Google Cloud Monitoring Dashboards

Go to the Google Cloud Console, navigate to Observability Monitoring and click Dashboards.
In the Dashboards Overview page, click Create Dashboard.
Click Add widget.
In the Add widget pane, select a widget to add to your dashboard. For this example, select Metric.

You can select a widget based on the type of data to display or how you want to display the data. In all cases, a configuration pane is opened. For example, you can select the Metric widget and then set the visualization to Stacked area. Or, you can select the Stacked area widget and then select the Metric.
In the Configure widget page, click Select a metric drop-down menu and select Autonomous Database. Under ACTIVE METRICS, select CPU Utilization and click Apply.
Click Apply to add the widget to the dashboard.

This will add the widget to the dashboard.
Repeat step 3 to 6 to add more widgets to the dashboard.
Click the dashboard name and rename it to Autonomous Database Dashboard.
Go back to Dashboards Overview to see the list of dashboards.
Click the newly created dashboard from the list of dashboards and change the time range to Today. See the following refreshed dashboard.

Acknowledgments

Authors - Vivek Verma (Master Principal Cloud Architect, North America Cloud Engineering)

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.

Title and Copyright Information

Monitor Oracle Database@Google Cloud using Google Cloud Monitoring

G28595-01