Extend Enterprise Manager 13.5 to gain Machine Learning driven insights

This post is part 2 in a 3 part series on how to get Oracle Enterprise Manager data into OCI Object Storage, how to leverage that data in OCI Operations Insight (this post) and how to leverage that data in OCI Logging Analytics . If you haven't read part 1, please set aside some time to read that.

You have the Oracle Enterprise Manager data in OCI Object Storage, now what?

Oracle Enterprise Manager (EM) is Oracle’s premier monitoring solution for on-premises and Cloud environments. Oracle Cloud Infrastructure services can take advantage of this valuable set of telemetry data to perform further resource analysis.

There are currently two OCI services that can analyze this data:

Oracle Cloud Infrastructure Operations Insights is an OCI native service that provides 360-degree insight into database and host resource utilization and capacity.

Oracle Cloud Logging Analytics is a cloud solution in Oracle Cloud Infrastructure that lets you index, enrich, aggregate, explore, search, analyze, correlate, visualize and monitor all log data from your applications and system infrastructure on cloud or on-premises. 

In this blog, we will highlight the kind of activities you can perform with the EM data in Operations Insights.

OCI Operations Insights using the Enterprise Manager data to discover the targets from Object Storage

◉ Operations Insights consists of the following integrated applications: 

◉ Capacity Planning (Databases & Hosts)

◉ Oracle SQL Warehouse

◉ Exadata Insights 

◉ AWR Hub

Features of Operations Insights are:

1. Analyze resource usage of databases/hosts across the enterprise

2. Forecast future demand for resources based on historical trends

3. Compare SQL Performance across databases and identify common patterns

4. Identify SQL performance trends across enterprise-wide databases

Operations Insights supports the following target types:

1. Autonomous Data Warehouse

2. Autonomous Transaction Processing

3. On-premises Oracle databases (11.2.04 and greater)

4. Pluggable Databases 12.1.0.2 and greater

5. Hosts (Linux only) where Management Agents are deployed or are monitored by Enterprise Manager (Version 13.5 Release Update 1 or later)

Prerequisites for configuring OCI Operations Insights 

◉ Enterprise Manager 13.5 Release Update 1 or above

◉ Database Plug-in version 13.5.1.0.0 or above

Data transfer from Enterprise Manager to Operations Insights is configured in two steps: 

◉ Set up target-level data transfer from Enterprise Manager to OCI Object Storage.

◉ Set up data transfer from OCI Object Storage to Operations Insights. 

Analyze Database Resources with OCI Operations Insights and utilize capacity planning for your organization

Operations Insights Capacity Planning functionality provides insight into resource and usage of the databases, thus allowing you to meet both peak and long-term database capacity for the organization.

From the upper left of the Oracle Cloud console select the navigation icon (looks like a hamburger) and then drop down the menu and navigate to → Observability & Management → Administration. Select EM Bridges and create the bridge to access the data from OCI Object Store Bucket. Follow the steps and add the required Dynamic Groups and Policies.

Select Database Fleet, Host Fleet & Exadata Fleet to add the targets exported from Enterprise Manager.

From the upper left of the Oracle Cloud console select the navigation icon (looks like a hamburger) and then drop down the menu and navigate to → Observability & Management → Capacity Planning → Databases.

Figure 1:  Database Capacity Planning

CPU Insights with Insights / Aggregate / Machine Learning feature prediction

Figure 2:  Database CPU for scp

Figure 3:  Trend & Forecast (emrep_iad1qg_EMPDB)

Similar capacity insights available for Storage, Memory and Database I/O

Analyze Host Resources with OCI Operations Insights

Operations Insights enables you to view current and predicted memory usage for both individual hosts and across multiple hosts. 

Figure 4:  Host Capacity Planning for scp

Hosts CPU Insights/ Aggregate / Machine Learning feature prediction

Figure 5:  Host CPU for Operations Insights

Figure 6:  Trend & Forecast

Analyze Exadata Insights with Operations Insights

Exadata Insights provides visibility into performance of critical workloads running on shared Exadata infrastructure monitored by Enterprise Manager. A single integrated view of all Exadata systems across your enterprise helps identify issues and troubleshoot them quickly. 

Figure 7:  Exadata System Capacity Planning for Exadatas 

Rack view and Key Metrics

Figure 8:  Rack view and key metrics

Exadata Database CPU /Storage/Memory/IO Insights

Figure 9:  Exadata Database CPU (Storage, Memory, IO Insights) 

Exadata Host CPU / Memory Insights

Figure 10:  Exadata Host CPU and Memory Insights

Exadata Storage Server analysis with OCI Operations Insights

Figure 11:  Exadata Storage Server analysis with OCI Operations Insights

 

SQL Warehouse with Operations Insights

Using the Oracle SQL Warehouse function of Operations Insights to analyze the SQL performance problems for enterprise-wide applications across a fleet of databases. In addition, Operations Insights provides trends and key insights to SQL performance issues thereby helps to be proactive in avoiding future problems.

Figure 12:  SQL Warehouse with Operations Insights

Top SQLs by CPU Utilization

Figure 13:  Top SQLs by CPU utilization

Top SQLs by I/O Utilization

Figure 14:  Top SQls by I/O utilization

AWR Hub with Operations Insights

AWR Hub helps to consolidate and store detailed performance data from the Automatic Workload Repository of your important Oracle Autonomous Databases.

Figure 15:  AWR Hub

To summarise, we can utilize the data from Enterprise Manager to get better insights and analytics with OCI services such as Operations Insights.

Read More: Enhancing Database and Apps Troubleshooting with ML Driven Log Analytics using EM OCI Bridge

Source: oracle.com