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.
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.
Figure 1: Capacity Planning application for external on-premises Oracle Databases main page
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
Figure 2: Oracle SQL Warehouse application for External on-premises Oracle Databases main page
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.
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.
Figure 3: Host Capacity Planning application for External on-premises Hosts main page
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.
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.