From the Database Capacity Planning Summary page, you can view current database resource utilization by CPU, storage, memory, and I/O . You can also compare and contrast resource usage between databases, and identify which databases use the most resources, and are expanding rapidly.

This page directly supports the goals of providing a birds-eye view of database resource usage and trends, and providing proactive insights into specific utilization issues either current or forecast for the near-term.

The Inventory section displays the total number of databases enabled for Ops Insights along with the database types. In addition, the CPU, Storage, Memory, and I/O usage charts display overall resource consumption (Top Consumers and Usage Trend) by these database targets.

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

CPU Insights, Storage Insights, and Memory Insights.

These sections show the number of databases running with low (0–25%) and high (75–100%) utilization of resources. For CPU utilization, it is the utilization percentage for the 90th percentile value of the daily average CPU usage over the selected time period. That is, if the 90th percentile value of CPU usage is associated with utilization above the 75% threshold, then the database is considered high CPU utilization.

For Storage and Memory utilization, it is the databases forecast to reach high utilization (>75%) or maintain low utilization (<25%) within the 0-30 day time period. Forecast training data are based on the selected historical data time period.

You can drill down to view the CPU, Storage or Memory breakdown for either individual databases or for an aggregated view of all databases.

Changing Utilization Thresholds

By default, Ops Insights sets the high and low utilization thresholds at 75% and 25%, respectively, for CPU, Storage, and Memory Insights. Customizing these forecast metric thresholds provides more granular capacity management forecasting, thus allowing you to be more proactive in resource management by setting threshold values that are more relevant to a specific target type for more accurate forecasting.

To change a utilization threshold:

1. Navigate to the Capacity Planning page.
2. For any of the Insights, click the information icon (i) next to the right of Utilization. These information icons are metric specific (i.e. if you launch from CPU Insights this modifies CPU-specific configurations), click on the icon specific to what threshold type you wish to modify. A descriptive pop-up dialog displays.
   
   
   
   
3. Click Edit Configuration. The Edit Configuration dialog displays.
4. Enter new alert threshold percentages under User interface settings for:
   • High Threshold
   • Low Threshold
   Enter new Alert metric settings for:
   • Forecast algorithm: Seasonally aware, Linear, or AutoML
   • Metric value: Average, or Maximum
   Note
   
   If you wish to reset any value to its default, click on Reset to default
5. Click Apply. Custom utilization thresholds apply to the current compartment.

Once applied, all Ops Insights statistics and forecast queries relying on these utilization thresholds will be updated to reflect the new threshold settings. For example, navigate to the CPU Insights. On the Aggregate tab, select Utilization Level from the Grouping drop-down menu. The aggregation chart, as well as Trend & Forecast chart, will reflect the new custom thresholds.

View and Download AWR Reports

To view and download available AWR Reports directly from the Capacity Planning page, locate the AWR reports column within the Database Details section. If the column is not visible scroll to the right to view. This will show a number amount of AWR Reports available for the chosen database, clicking on the number will provide a slide out menu with all reports for that database listed.

In the AWR Reports slideout select and click the AWR report name you wish to review, and select whether to View or Download the report. You can also search for a specific report using the search bar, or refine your search/view by selecting a different time range.

View Capacity Planning in Database Management

With Ops Insights enabled you can also view a Capacity Planning dashboard through Database Management. The dashboard shows last 30 days of data (with 15 a day forecast). Drill downs are available via the title (i.e. CPU) linking to Capacity Planning, allowing you to do a more customized forecasting.