Analyze Exadata Resources
Exadata Insights provides visibility into performance of critical workloads running on shared Exadata systems either cloud-based (Exadata Cloud Service) or monitored by Enterprise Manager (Exadata Database Service on Dedicated Infrastructure, Exadata Database Machine, and Exadata Cloud@Customer). A single integrated view of all Exadata systems across your enterprise helps identify issues and troubleshoot them quickly. You can also view the categorization of the Exadata systems based on the fleet type (Exadata Database Machine Bare Metal, Exadata Database Machine Virtualized, Exadata Cloud@Customer, or Exadata Database Service on Dedicated Infrastructure), rack type, the systems with low resource utilization, and the global resource usage in terms of CPU, memory, I/O, and storage.
- Get combined infrastructure resource utilization and workloads running across a set of Exadata systems
- Analyze the capacity utilization for host and storage infrastructure, do a capacity planning for database workloads, and get insights into the system performance trends
It takes up to 24 hours for the Exadata associations to be extracted from the Enterprise Manager repository to the object store and visible within Operations Insights.
Make sure that Auto-Sync for Exadata Systems is enabled, failure to do so may cause a lack of information to be displayed.
For Exadata Explorer related data objects see: Data Object Explorers.
Typical Tasks for Analyzing Exadata Resources
As an administrator or capacity planner, perform these tasks using Exadata Insights to analyze how your different Exadata Database Machine resources are being used.
| Task | Description | More Information |
|---|---|---|
| Identify the top resource consuming Exadata Database Machine systems. | View the Exadata Database Machine systems running with low resource utilization and high resource utilization. | Identify the Top Resource Consuming Exadata Systems |
| Analyze the critical Exadata Database Machine systems. | View the different Exadata Database Machine systems that are projecting to reach high utilization. | Analyze the Critical Exadata Systems |
| Analyze the spare capacity for new workloads. | Analyze the different Exadata Database Machine systems with maximum resources available for the new workloads. These systems are forecasted to be using low resources for the next six months. | Analyze the Spare Capacity for New Workloads |
Identify the Top Resource Consuming Exadata Systems
To get a unified view of your enterprise-wide resource utilization and performance of Exadata Database Machine systems from the Operations Insights main menu, click Exadata Insights to display the fleet-wide Exadata System Capacity Planning dashboard.
The Exadata System Capacity Planning dashboard, lets you view the global Exadata System Inventory, resource utilization by CPU, Exadata Storage, Memory, and Input/Output Per Second (IOPS) for all Exadata Systems. You can also compare current and forecasted resource usage between Exadata Systems, and identify which systems could potentially run into problems due to current high utilization, or may run into problems in the future per forecasted high utilization.
The Current Utilization and Forecast for Exadata Systems table provides a quick view into which systems need immediate attention. The table shows you highest resource utilization metric for each Exadata System and, if not already exceeded, when the high utilization threshold (above 75%) will be exceeded in the near future. For further analysis, you can drill down into individual Exadata Systems for a detailed look at system resources.
Analyze the Critical Exadata Systems
From the Exadata System Capacity Planning dashboard, you easily identify systems that are projected to reach high utilization. You can then drill down into individual systems for a detailed look at system resources to identify specific issues.
For each Exadata System, you can get a detailed look at the following resources:
Rack and Key Metrics
This provides you with a detailed look at the components of the rack such as Software Inventory (Oracle Databases, Clusters, etc.) , Hardware Inventory (PDUs, Storage Servers, InfiniBand Switches, Ethernet Switches, and Servers) and all key monitoring metrics for the system (Exadata Storage, CPU, IOPS, and Memory).
Metrics by Database
This provides a detailed look at CPU, Storage, Memory, and I/O utilization across all databases in the system. The volume of resources used and the percentage change are represented visually, through the size and color of the cells, respectively. Cells that are larger in size use more storage resources than smaller cells. The largest cell would be that of the databases using the most resources. The color of the cells is determined by the percent utilization (highest utilized) in the storage resources used by the databases.
To analyze resource utilization across a subset of databases, use the Group menu to group databases according to CDB, HOST, Database Type, Utilization Level, CDB, Host, VM Cluster (All Exadata Database Services discovered with Enterprise Manager 13.5 Release Update 8 [13.5.0.8] onward), Freeform Tags, or Defined Tags. Click on a specific group to view the trend and forecast for resource utilization for all databases within the group. For more information on group tags see: Group by Tags.
For Operations Insights to forecast your resource utilization for a year, there must be at least 12 months of stored data. The forecast value is more accurate when there’s more data.
The 0–25% resource utilization is considered as low utilization, and 75–100% utilization of resources is considered as high utilization.
You can use the Trend & Forecast utilization chart to plan your database resource capacity.
To verify trend accuracy for both Exadata databases and hosts, you can compare historical data with forecasted trends using Forecast Backtesting. See Forecast Backtesting for more information.
For Virtualized Exadata systems the CPU and Memory metrics shown are for the Virtual Machine.
Exadata Storage Server: This provides you with a detailed look at individual clusters and diskgroups that comprise the Exadata Storage Server. Total Usable Storage is shown for each cluster, in addition to IOPS and Throughput.
You can view data as Individual data series in order to view trends for separate diskgroups/storage servers, or Aggregate data series and forecast where you can view a summed total of diskgroup/storage server data that provides insight into the overall performance of the cluster instead of individual diskgroups or storage servers.
Analyzing an Exadata System
You can analyze the CPU, memory, and I/O resources that are capacity bottleneck using the forecasted data. Use this information to identify the top databases consuming host CPU, memory, storage disk, or I/O resources.
To resolve a capacity bottleneck:
- Relocate the high resource consuming databases.
- Find if the CPU usage increment is caused by bad SQL.
- Consider adding more servers.
Analyze the Spare Capacity for New Workloads
Analyze and identify the Exadata Systems with the most available capacity for placing new or migrating existing workloads.
The Exadata Database Machine systems that currently have a low resource utilization, and are forecasted to maintain a low resource utilization for the next six months, are candidates to take on additional workloads.