Analyze Exadata Resources

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. You can also view the categorization of the Exadata systems based on the fleet type (Exadata Database Machine), rack type, the systems with low resource utilization, and the global resource usage in terms of CPU, memory, I/O, and storage.

As an IT administrator or a capacity planner, you can use this application to optimize capacity based on proactive planning.

Get combined infrastructure resource utilization and workloads running across a set of Exadata systems (Exadata Database Machine). Analyze the capacity utilization for host and storage infrastructure, do a capacity planning for database workloads, and get insights into the system performance trends.

Prerequisites

Before you begin, ensure the following:

  • IMPORTANT: Enterprise Manager configuration (setting up the OCI Bridge) MUST be done first. See Integrating Enterprise Manager with OCI Services.
  • EM Bridge and Object Storage bucket has been set up. See Adding Enterprise Manager Targets.
  • Enable Exadata Systems for Operations Insights
    Note

    Only Exadata Database Machines and Exadata Cloud at Customer deployments monitored by Enterprise Manager are currently supported.
  • Exadata Insights is compatible with the following versions of Enterprise Manager:
    • On-premises (Exadata Database Machine): Enterprise Manager 13c Release 5 Update 7 (13.5.0.7) and greater
    • Cloud Service (Exadata Customer at Cloud): Enterprise Manager 13c Release 5 Update 4 (13.5.0.4) and greater

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.


Graphic shows the Exadata Insights home dashboard

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).


Graphic shows the Rack and Key Metrics resources page.

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.


Graphic shows the Metrics by DB resource page.

To analyze resource utilization across a subset of databases, use the Group menu to group databases according to CDB or HOST. Click on a specific group to view the trend and forecast for resource utilization for all databases within the group.

Note

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.

Note

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.

Metrics by Host: This provides you with a detailed look at CPU and Memory (logical memory) utilization across all hosts in the system. The utilization chart and Trend & Forecast chart are functionally similar to those used for Metrics by Database.

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.
Graphic shows the Exadata Storage Server resource page.

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:

  1. Relocate the high resource consuming databases.
  2. Find if the CPU usage increment is caused by bad SQL.
  3. 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.