Exadata Analytics using Oracle Management Cloud Now Includes Exadata Cloud Service (ExaCS) and Cloud at Customer (ExaCC)

Oracle Management Cloud (OMC) provides a unified view of your enterprise-wide resource utilization and performance of all of your Exadata systems.  In our recent release (OMC 1.50), we’ve expanded our coverage to support Exadata Cloud Service (ExaCS) and Cloud at Customer (ExaCC). Prior to this support, ExaCS and ExaCC could only be monitored generically via OMC IT Analytics.

In this blog, we’ll focus on what OMC IT Analytics can do for ExaCS and ExaCC customers.  For the full picture of on-premise Exadata monitoring and management, see the “Exadata Cloud Service Best Practices Using Oracle Enterprise Manager and Oracle Management Cloud” blog, the “Oracle Enterprise Manager for Exadata Cloud: Implementation, Management, and Monitoring Best Practices” Whitepaper, or Enterprise Manager for Exadata Management Documentation.

A Brief Recap of Oracle Management Cloud IT Analytics

Oracle IT Analytics provides 360-degree insight into the performance, availability, and capacity of IT investments.  It looks at 13 months of data providing the benefit of a full fiscal (or calendar) year in hindsight.

OMC IT Analytics has a specialized focus on Exadata Analytics that:

• Drives Oracle Exadata utilization by consolidating databases; automatically compares and forecasts Oracle Exadata resource usage over time—including seasonality trends—to predict future growth rates

• Optimizes resource capacity to meet demand. With machine learning, you can project future capacity needs based on intelligent forecasts of database workload growth.
• Deliver insights into workload performance. A single-pane-of-glass view enables insights across the entire Oracle Exadata estate

See the Complete View of Your Exadata Systems

Get a unified view of your enterprise-wide resource utilization and performance of ExaCS, ExaCC, and on-premises Exadata systems in the Overview page of the Exadata Analytics application.

Figure 1.  Overview Page of Exadata Analytics

This includes insight into Exadata Storage systems and helps you run capacity planning exercises and performance analysis on your ExaCS and ExaCC systems.  Additional specific features now available include:

• Unified fleet view of ExaCS, ExaCC, and on-premises Exadata
  • Provides inventory, capacity, and performance overview
• Capacity analysis, resource usage, and performance in context of ExaCS and ExaCC
• Forecasting of future capacity needs for ExaCS, ExaCC
• Exadata host analysis, storage capacity, and performance for ExaCS, ExaCC
• Ability to enable/disable OMC Enterprise Edition license at the ExaCC / ExaCS level
• New entity type “Oracle Exadata Cloud” in OMC

Looking at the Exadata Estate

It’s important to understand where your critical databases are running and identify if there will be Database Machine bottlenecks, or which Exadata Systems have available capacity headroom to support consolidation of additional databases.  Let’s take a look at some of the consolidated views across the Exadata estate.

Examine a consolidated view of Exadata Service Types including Exadata Database Machine, Exadata Cloud at Customer, and Exadata Cloud Service.

Figure 2.  List of Exadata System Types

Figure 3.  Count of Database Versions Across Different Exadata System Types

Figure 4. Resource Utilization Across All Systems

Exadata Analytics also provides the Exadata Systems with low utilization that could potentially be used to address the Exadata Systems running out of resources.

Figure 5. Exadata Systems with Predicted Low Utilization for the Next 6 Months

Figure 6. View Global Resources Across your Exadata Estate

Examining an Exadata Cloud Service

Now that we’ve looked at a consolidated view across your Exadata resources, let’s drill down into Exadata Cloud Service and look at some of the Exadata Analytics Insights on database and host performance resources.

Figure 7.  Inventory in ExaCS.

At the top level for ExaCS, we are shown the consolidated view of host, memory, IOPS, and Exadata storage utilization and headroom with an estimated time until they reach high utilization.  We also see a summarized view of database performance showing degradation, workload variability and database inefficiency.

Figure 8.  ExaCS Resource and Database Performance Insights

Now let’s look at the top Finance databases and hosts performance and resources showing used CPU, Memory, and Storage and their growth percentages.

Figure 9.  ExaCS Top Databases

Figure 10.  ExaCS Hosts Showing CPU and Memory with Estimated Days to Capacity

Lastly, let’s examine the Exadata Storage Server.

Figure 11.  ExaCS Storage Showing Memory, Diskgroups, and Space Used

Figure 12.  ExaCS Storage Server I/O and Throughput with Estimated Days to Capacity

What Needs to be Done to Support ExaCS and ExaCC in Oracle Management Cloud

ExaCS and ExaCC entities are supported in Oracle Management Cloud 1.50 release (August 2020).  Here is a quick summary of the important requirements:

• Similar to Exadata on-premise, Enterprise Manager 13.4 Cloud Control needs to have discovered the ExcCS and ExaCC targets.

• For Oracle Management Cloud, there are a few configuration versions to validate
  • OMC 1.50 Data collector is deployed
  • OMC Cloud Agent is deployed on user domain domU of ExaCS, ExaCC
  • For Networking, the service gateway must be used on ExaCS
  • For licensing, OMC EE License must be enabled

For more information, see OMC IT Analytics and Exadata.  Or for more general information, see OMC IT Analytics.