Analyze Database Resource Usage

Using Database Resource Analytics, you can view your current database resource utilization by CPU, memory, I/O, and storage. You can also view the interconnect activity details for a selected database. You can also compare and contrast resource usage between databases, and identify which databases use the most resources, and are expanding rapidly.

When you log in to the application, the Overview page is displayed. The Inventory section displays the total number of databases along with the database types. The pie chart also depicts this information. When you check the Show Oracle Autonomous Databases option, the pie chart displays the breakup of the Oracle databases into Autonomous Data Warehouse (ADW) databases and Autonomous Transaction Processing (ATP) databases. In addition, the CPU and Memory usage charts will display a separate line to show the resource consumption by these database targets.

The Resource Utilization section shows the current utilization of databases and the databases that are reaching the server capacity headroom.

• Current Utilization of Database Systems

  This section shows the number of database systems running with 0–25%, 25–50%, 50–75%, and 75–100% utilization of resources. This categorization is based on CPU and memory utilization. The current utilization of some database 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 the low utilization range, and the bucket with 75–100% utilization of resources is considered as the high utilization range.

  You can drill down to view the CPU and memory breakdown by individual databases and for an aggregated trend and forecast view.

• Database Systems Projected to Reach High Utilization

  This section shows the number of database systems that are forecasted to reach high resource utilization threshold, in the next 30, 90, 180, and 180+ days. This forecast cannot be calculated for some database systems if the available data is insufficient. The forecast for such database systems is categorized as ‘Unknown’. The database systems fall into different buckets depending on the utilization threshold values that you set in the IT Analytics Settings page. See Configure Capacity Thresholds for Your Environment.

  You can analyze the CPU and memory resources that are capacity bottleneck by using the forecasted data. Use this information to identify the databases running on systems that are under-provisioned, resulting in performance degradation.

  Note:

  You can also view the forecast of resource utilization of database systems for 365+ days. You can add this time range from the IT Analytics Settings page. See Configure Capacity Thresholds for Your Environment.

  You can drill down to check for the databases that are forecasted to run out of capacity in future.

The CPU, Memory, Allocated Storage, and I/O utilization charts show the overall usage of these resources. To view detailed information about each of your critical database resources, click the corresponding tile in the navigation pane.

You can view the following information for each resource (CPU, memory, storage, I/O):

• Aggregate resource utilization across all databases: View the summary of resource utilization across all databases, which helps identify points in time where there may have been unexpected spikes in resource utilization.

• Resource breakdown by individual databases: View the resource utilization for each database, which helps compare resource utilization between databases, and identify servers with underused or overused resources. The size of the cells shows the volume of resources used by the specific database. The color of the cells show the rate of change, where red implies that the database is growing rapidly, green implies that the database is shrinking, and grey implies no change in the resources used by the database.

• Trend and Forecast: See the forecasted utilization for the particular resource, along with the current utilization trend. Use this information for capacity planning.