The Capacity Planning application lets you understand and analyze trends in the utilization of critical database and host resources, such as CPU, storage, or memory. You can also analyze, compare, and contrast resource usage across multiple databases and hosts.

As an IT administrator or a capacity planner, you can use database and host Capacity Planning to understand how critical resources, including CPU and storage are used. Capacity planning ensures that your enterprise databases and hosts have sufficient resources to meet future business needs.

The Capacity Planning application provides you with:

• Accurate and agile expense planning and management for core compute resources
• Proactive detection and avoidance of unexpected resource capacity issues
• Deeper understanding of fleet-wide distribution and usage of compute resources
• Insight into database or host-specific trends and patterns of resource usage

You can trend daily and hourly aggregates of resource usage over time and project demand into the future for individual databases and hosts or in aggregate.

You can view the entire compartmental (or cross-compartmental hierarchy) fleet of databases/hosts and compare the distribution of resources by allocation, utilization, and growth rates.

Operations Insights Capacity Planning computes forecasts for CPU and Storage on-demand and proactively singles out databases/hosts predicted to have utilization issues within the forecast horizon.

The Oracle SQL Warehouse application makes it easy for you to manage SQL at scale.

Using the Oracle SQL Warehouse application of Operations Insights, you can analyze the SQL performance problems for enterprise-wide applications across a fleet of databases. In addition, Oracle SQL Warehouse provides trends and key insights to SQL performance issues thereby helping you to be proactive in avoiding future problems.

With Oracle SQL Warehouse, you can:

• Collect SQL, execution plan and session data into a long term Oracle SQL Warehouse and store data for 25 months
• Compare SQL execution plan between production, test and development database
• Compare SQL performance trends across databases and drill down to execution plans for analysis
• Identify SQL statements that were good but now turned bad even if the execution plan has not changed
• Auto-detect anomalies by comparing current SQL response time vs. automatic baselines

Exadata Insights lets you analyze the resource utilization of Exadata systems (Database Machines, Cloud Service, and Cloud@Customer), and identify the spare capacity for new workloads. This gives you a holistic view of all Exadata systems across your enterprise to help optimize capacity based on proactive planning, and drive database consolidation use cases.

With Exadata Insights, you can:

• Analyze resource usage of databases/hosts across the enterprise
• Forecast future demand for resources based on historical trends
• Compare SQL performance across databases and identify common patterns
• Identify SQL performance trends across enterprise-wide databases

The Oracle Database Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for the database that can later be displayed in both reports and views. A built-in AWR repository, that exists in every Oracle Database, stores this data. AWR data contains important performance statistics about the Oracle Database and can be used for Oracle Database performance, diagnostics, and tuning.

To handle AWR data from multiple databases, Operations Insights provides AWR Hub, a cloud-based repository that collects and consolidates AWR snapshots from multiple databases in your OCI tenancy.

With AWR Hub, you can:

• Track and analyze SQL plan changes for workloads within a single database
• Track and analyze SQL plan changes for workloads across multiple databases
• Understand past and present workload (SQL) performance over a period of two years or above.
• Build custom dashboards to plot SQL performance statistics, database waits, CPU usage history, connections established, etc.

Automatic Database Diagnostic Monitor (ADDM) is an expert system that analyzes data captured in the Automatic Workload Repository (AWR) snapshots to review performance analysis.

Operations Insights harvests and interprets ADDM data from your source databases and highlights these findings and recommendations.

Operations insights harvests and stores ADDM data for a duration longer than the event itself, providing you with the ability to analyze ADDM findings and recommendations for a collection of events into the past which may no longer exist in the source database.

Supported Versions ADDM Spotlight supports Virtual Machine, Bare Metal, databases managed by Management Agent, and non PDB databases version 18c and above.

Oracle Enterprise Manager (EM) provides a single solution to manage all of your Oracle deployments, both in your data center and in Oracle Cloud. EM Warehouse provides a convenient way to access and analyze this data using cloud-based tools and services.

The EM repository contains critical information such as operational, performance and configuration metrics, and target inventory data for the targets monitored by Enterprise Manager.

EM Warehouse provides easy access to the wealth of information stored in the repository and allows you to use your preferred analytics tools to analyze the data. You can use tools such as:

• Jupyter Notebooks
• SQL Queries
• Oracle Analytics Cloud

SQL Explorer provides an easy-to-use interface that lets you interactively explore and visualize detailed performance statistics stored in Operations Insights SQL Warehouse.

With SQL Explorer, you can explore performance statistics via a SQL query to extract the data with which to create an intuitive visualization. This provides interactive data exploration and visualization for deep exploration of application SQL performance statistics. The user interface is designed to simplify and streamline query development.

SQL Statistic Metric Collection is supported in SQL Explorer for Enterprise Manager Cloud Control managed databases. In order for these metrics to be collected Enterprise Manager 13.5 Release Update 13 (13.5.0.13) or higher is required, as well as Database Plug-in version 13.5.0.13, and set up the Enterprise Manager Bridge.