About Oracle Cloud Infrastructure Operations Insights

Oracle Cloud Infrastructure Operations Insights is an OCI native service that provides holistic insight into database and host resource utilization and capacity.

Operations Insights consists of the following integrated applications:

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
  • Analyze AWR statistics for database performance, diagnostics, and tuning across a fleet of databases

Demo Mode

To explore Operations Insights functionality before setting up your own environment. See Explore Operations Insights Using Demo Mode.

Related Services

Operations Insights also provides direct access to the Oracle Cloud Infrastructure Database Management service, which lets you take advantage of its real-time database performance and management capability with a single click. For more information, see Accessing Related Services.

Supported Targets

Operations Insights supports the following target types:

  • Autonomous Data Warehouse
  • Autonomous Transaction Processing
  • On-premises Oracle Databases (11.2.0.4 and greater)
  • On-premises Pluggable Databases (12.1.0.2 and greater)
  • Database Cloud Service Databases (19c and greater)
  • Database Cloud Service Pluggable Databases (19c and greater)
  • Exadata Cloud at Customer (monitored by Enterprise Manager 13c Release 5 Update 4 (13.5.0.4) and greater)
  • On-premises Database Machine targets
  • Hosts Target Types
    • Linux Requirements: Linux hosts must either have Management Agents deployed or be monitored by Enterprise Manager 13c Release 5 Update 1 (13.5.0.1) and greater
    • zLinux with Redhat Enterprise Linux Requirements: Hosts must be monitored by Enterprise Manager 13c Release 5 Update 1 (13.5.0.1) and greater
    • zLinux with Suse Enterprise Linux Requirements: Hosts must be monitored by Enterprise Manager 13c Release 5 Update 4 (13.5.0.4) and greater
    • Solaris Requirements: Solaris hosts must be monitored by Enterprise Manager and have been added to the Enterprise Manager group containing targets uploading data to OCI

      For more information, see Adding Enterprise Manager Targets and Using OCI Services with Enterprise Manager.

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 resource.
  • Oracle Cloud Infrastructure applies throttling too 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.

Capacity Planning

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.

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

Exadata Insights

Exadata Insights lets you analyze the resource utilization of Exadata systems (Database Machines) monitored by Enterprise Manager, and thereby 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.

Note

This feature is available for Exadata systems that are managed by Oracle Enterprise Manager 13c Release 5 Version 1 (13.5.0.1) and above.

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

AWR Hub

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.

Enterprise Manager Warehouse

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

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.