Typical Goals

As a database fleet administrator or capacity planner, the Capacity Planning application lets you perform the following use case goals at the compartment level (or cross-compartmental hierarchy) for both CPU and storage resources.

What you want to do: How to get it done:
  • Obtain a birds-eye view of aggregate database CPU allocation, utilization and usage trends
  • Gain proactive insights into current CPU or Storage utilization issues or forecast to occur near-term
  • View fleet-wide distribution of allocated database CPU resources and their utilization levels
  • Trend and forecast aggregate CPU utilization for all or specific groups of databases
  • Trend and forecast aggregate Storage utilization for all or specific groups of databases
Compare CPU Utilization Between Databases
Trend and forecast CPU utilization for specific databases of interest CPU Details - Insights Table
Trend and forecast Storage utilization for specific databases of interest Storage Details - Insights Table
  • Obtain a birds-eye view of aggregate database Storage allocation, utilization and usage trends
  • View fleet-wide distribution of allocated database Storage resources and their utilization levels
Compare Storage Utilization Between Databases
  • Estimate the opportunity cost of resource allocation for highly variable CPU demand
  • Identify candidates for Oracle Autonomous DB auto-scaling of CPU
CPU Details - Trend & Forecast
View, download, and analyze AWR Reports View and Download AWR Reports