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.
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:
- Capacity Planning
- Exadata Insights
- SQL Insights
- Oracle SQL Warehouse
- SQL Explorer
- ADDM Spotlight in Ops Insights
- News Reports
- AWR Hub
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- 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
- 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 |