Analyze the Critical Exadata Systems

You can analyze the critical Exadata systems (Exadata Database Machine, Exadata CC and Exadata CS) which may reach capacity in 30, 90, 180,365, 365+ days, using Exadata Analytics.

The Exadata Systems Projected to Reach High Utilization section shows the number of all different types of systems that reach the high threshold in terms of capacity, in the next 30, 90, 180, 365, and 365+ days. 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.

You can drill down to check the different types of Exadata systems that are forecasted to run out of capacity in the future. Click on each of the different Exadata systems to view these details.

The Resource Insights table displays the current usage and the reaching capacity of the selected Exadata system with respect to CPU, memory, I/O, and Exadata 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 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 the storage, I/O, and throughput

To resolve the 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.