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:
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:
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: