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
- Enterprise Manager 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 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
Ops Insights supports the following target types:
- 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)
- Pluggable Databases and Container Databases (19c and greater)
- Exadata on Oracle Public Cloud (with databases 19c and greater)
- On-premises Database Machine targets (Bare Metal and Virtualized)
- Hosts Target Types
- Linux Requirements: Linux hosts must either have Management Agents deployed or be monitored by Enterprise Manager 13c Release 5 Update 10 (13.5.0.10) 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 10 (13.5.0.10) 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 Integrating Enterprise Manager with OCI Services.
- Microsoft Windows: Hosts must either be monitored by Enterprise Manager 13c Release 5 Update 4 (13.5.0.4) and greater, or reside in an OCI Compute instance where the host is monitored by the Management Agent Cloud Service.
- AIX: AIX hosts must be monitored by Enterprise Manager and have been added to the Enterprise Manager group containing targets uploading data to OCI.
- HP-UX: HP-UX hosts must be monitored by Enterprise Manager and have been added to the Enterprise Manager group containing targets uploading data to OCI.
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 instance that has Ops 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 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 |
* Applicable for capacity planning and Oracle SQL Warehouse applications only.
**Applicable for SQL Explorer, SQL Insights, and ADDM Spotlight.
Warehouse Pricing
- AWR hub
- Enterprise Manager Warehouse
- 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, EM Warehouse |
| Ops Insights for Warehouse - Extract | $2.00 | Gigabyte per month | AWR Hub, EM Warehouse and Exadata Warehouse |