Oracle Cloud Infrastructure Operations Insights is an OCI native service that provides 360-degree insight into database and host resource utilization and capacity.
Operations Insights consists of two integrated applications:
- Capacity Planning
- Oracle SQL Warehouse
These applications allow database administrators, DevOps, and IT executives to make critical decisions about their databases and hosts using historical and long term data.
With Operations 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
Operations Insights supports the following target types:
- Autonomous Data Warehouse
- Autonomous Transaction Processing
- On-premises Oracle databases (11.2.04 and greater)
- Pluggable Databases 184.108.40.206 and greater
- Hosts where Management Agents are deployed
Before You Begin
- Data collected and analyzed by Operations Insights Service will only be stored for the last 25 months from the current date.
- Data collected and analyzed by Operations Insights Service will be purged after 30 days once the Operations Insights Service is disabled on a database.
- Oracle Cloud Infrastructure applies throttling to many API requests to prevent accidental or abusive use of resources. If you make too many requests too quickly, you might see some succeed and others fail.
- Pricing does not depend on the actual amount of data stored.
- Stopping an Oracle Database or instance that has Operations Insights enabled has no effect on retention or visibility of historical data for that instance. The period during which the Oracle Database or instance was stopped will contain no data.
- If the data was not collected from the source databases or targets for some underlying reason then that period will contain no data for Operations Insights.
- Oracle SQL Warehouse application of Operations Insights Service requires Oracle Diagnostics Pack on the source database.
- Operations Insights Service also uses Oracle Cloud Infrastructure Monitoring Datapoints – Retrieval (Part# is B90926). You may get charged for it over and above the free limits offered by Oracle.
Operations Insights Capacity Planning provides deep insights into the allocation and usage of CPU, storage, memory, and I/O resources by databases within an OCI compartment, databases monitored by Oracle Enterprise Manager Cloud Control, or hosts and databases monitored by an OCI Management Agent service.
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
- Data-driven decision making for Autonomous Database resource allocation
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 fleet of databases/hosts and compare the distribution of resources by allocation, utilization, and growth rates.
Operations Insights Capacity Planning regularly computes 30 and 90-day utilization forecasts for both CPU and Storage and proactively singles out databases/hosts predicted to have utilization issues within the forecast horizon.
Oracle SQL Warehouse
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