About Oracle Cloud Infrastructure Ops Insights

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

Note

Operations Insights has changed its name and is now Ops Insights. This change is visible starting March 2024.

Ops 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 Ops 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
  • Create and receive weekly News Reports giving you breakdowns of new utilization highs, big utilization changes and inventory changes across your fleet of databases, hosts, and Exadata systems.

Demo Mode

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

Related Services

Ops 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

For a complete list of Ops Insights supported targets and configurations see: Supported Configurations for Ops Insights.

Before You Begin

  • Data collected and analyzed by Ops Insights Service will only be stored for the last 25 months from the current date.
  • Data collected and analyzed by Ops Insights Service will be purged after 30 days once the Ops 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 an MySQL Database that has Ops Insights enabled has no effect on retention or visibility of historical data for that instance. The period during which the database resource 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 Ops Insights.
  • Oracle SQL Warehouse application of Ops Insights Service requires Oracle Diagnostics Pack on the source database.
  • Ops 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.

Licensing for Ops Insights

Generic Pricing
The following features are applicable to the SKUs listed below:
  • Capacity planning (database and host)
  • Exadata Insights
  • SQL Insights
  • Oracle SQL Warehouse
  • Data Object Explorer
  • ADDM Spotlight
  • Dashboard
Configuration (SKU) Pricing Metric Details
Cloud databases (B892889)** $0.015 OCPU per hour Supports *Oracle Base Database, *Exadata Database Service on Dedicated Infrastructure, and Autonomous database enabled for OPSI full feature support (configured for OCPU
External and On Premise databases and hosts (B92890) $0.015 Host CPU core per hour On premise databases with diagnostics and tuning pack
Autonomous Database basic (B92888)* $0.00 OCPU per hour N/A
Autonomous Database basic (B96199)* $0.00 ECPU per hour N/A
Autonomous Database full * $0.0075 ECPU per hour N/A
Oracle Ops Insights for MySQL HeatWave (B109358) $0.015 OCPU per hour Oracle SQL Warehouse, ADDM, Exadata are not applicable for MySQL.
Oracle Ops Insights for MySQL HeatWave (B109359) $0.0075 ECPU per hour Oracle SQL Warehouse, ADDM, Exadata are not applicable for MySQL.

* Applicable for capacity planning and Oracle SQL Warehouse applications only.

**Applicable for SQL Explorer, SQL Insights, and ADDM Spotlight.

Warehouse Pricing

The following features are applicable to the SKUs listed below:
  • AWR hub
  • Exadata Warehouse
Configuration (SKU) Pricing Metric Details
Oracle Autonomous Data Warehouse BYOL (B89039) $0.3226 OCPU per hour Exadata Warehouse
Oracle Autonomous Data Warehouse (B89040) $1.3441 OCPU per hour Exadata Warehouse
Ops Insights for Warehouse - Instance (B93706) $0.5377 OCPU per hour AWR Hub
Ops Insights for Warehouse - Extract $2.00 Gigabyte per month AWR Hub and Exadata Warehouse