We’re pleased to announce support for external on-premises Oracle databases and hosts in Oracle Cloud Infrastructure Operations Insights service, providing capacity planning and long-term SQL performance analysis for Oracle Database service. Operations Insights service helps optimize resource utilization and maximize database performance.

External on-premises Oracle databases

You can now manage and monitor Oracle databases outside of OCI, using OCI’s External Database service.

The new release of Operations Insights provides the following applications for external on-premises Oracle Databases.

  • Capacity Planning: Analyze and forecast external on-premises Oracle Database resource consumption using long-term historic data and machine learning. Optimize resource use by identifying and managing over and underutilized servers.

  • Oracle SQL Warehouse: Fleet-wide historical data store for high-impact SQL for external on-premises Oracle databases to get key insights into SQL performance degradation, execution plan histories, variation across fleet.

Capacity Planning

A screenshot of the Capacity Planning application in the Console.
Figure 1: Capacity Planning application for external on-premises Oracle Databases main page

Use cases

  • Aggregate database CPU, storage, memory, IO utilization, and trends

  • Top databases by allocation, usage, and change %

  • Insights into current or forecast near-term CPU, storage, memory, and IO utilization issues

  • Fleet-wide distribution of CPU, storage, and memory allocated and used

  • Trend and forecast CPU, storage, memory, and IO utilization for specific databases

Oracle SQL Warehouse

A screenshot of the Oracle SQL Warehouse application in the Console.
Figure 2: Oracle SQL Warehouse application for External on-premises Oracle Databases main page

Use Cases

  • Insights into historical SQL performance across multiple dimensions, including performance degradation, unpredictable performance, application inefficiencies, and changing execution plans.

  • Find common patterns of SQL performance issues across fleet of forecast external on-premises Oracle databases.

  • Compare SQL performance across external on-premises Oracle databases in production, development, and test environments.

External on-premises hosts

Operations Insights service adds a new host capacity planning application that lets you analyze and forecast utilization trends for host resources CPU and memory of external on-premises hosts.

A screenshot of the Host Capacity Planning application in the Console.
Figure 3: Host Capacity Planning application for External on-premises Hosts main page

Use Cases

  • Obtain an overview of aggregate host CPU and memory allocation, utilization, and usage trends.

  • ain proactive insights into current CPU and memory utilization issues or forecast to occur near-term.

  • Trend and forecast CPU and memory utilization for specific hosts of interest.

  • View fleet-wide distribution of allocated host CPU and memory resources and their utilization levels.

  • Trend and forecast aggregate CPU and memory utilization for all or specific groups of hosts.

Conclusion

Get started today!

You can find Operations Insights under Monitoring and Diagnostics in the Oracle Cloud Infrastructure Console menu. Oracle Cloud Infrastructure Operations Insights service helps you with optimizing resource utilization of Oracle databases, hosts and maximizing Oracle database performance. You can access Operations Insights through the OCI Console, CLI, and REST API. It’s available in all commercial regions and Government regions coming soon. For more information on Operations Insights, see the technical documentation.