Analyze the Top Resource Consuming Exadata Systems

You can analyze the resource utilization of the different types of Exadata systems (Exadata Database Machine, Exadata CS and Exadata CC) using Exadata Analytics, and thereby identify the spare capacity for new workloads.

The Current Utilization of Exadata Systems section shows the number of Exadata systems running with 0–25%, 25–50%, 50–75%, and 75–100% utilization of resources. This categorization is based on CPU, memory, I/O, and storage utilization. The current utilization of some Exadata systems cannot be calculated if the available data is insufficient. The resource utilization for such database systems is categorized as ‘Unknown’.

The bucket with 0–25% resource utilization is considered as low utilization, and the bucket with 75–100% utilization of resources is considered as high utilization.

You can drill down to view the resource and performance insights for the different types of Exadata systems with the preferred range of resource utilization. Click the preferred range to view these details.

The Resource Insights table displays the current usage and the number of days after which the selected Exadata system is expected to reach capacity with respect to host CPU, host memory, IOPS, and storage.

The Performance Insights section lists the databases with performance degradation, databases with highly variant performance, and the inefficient databases in the selected Exadata system.

Click View Details for the selected Exadata system to view the following:

• Exadata system inventory

• Resource and performance insights of an Exadata system

• Top databases by the resource type CPU, memory, I/O, and storage

• Top hosts by the resource type CPU and memory

• Top Exadata storage servers by storage, I/O, and throughput