Supported Configurations for Ops Insights
The following chart highlights supported configurations Yes for Ops Insights
Table 2-1 Ops Insights Service Availability
| Service | Ops Insights Availability |
|---|---|
| OCI Database Cloud Service Databases | Bare Metal, Virtual Machine, Pluggable Databases 19c and above, and Non-Container Databases 12c and above
Oracle Standard Edition databases. |
| Agent- Monitored External Databases and Hosts (on-premises) | Linux, Solaris Sparc, Windows, AIX
Currently Ops Insights is unable to view database targets monitored by a MACS agent on Windows systems. |
| Enterprise Manager Databases and Hosts (on-premises) | Linux, zLinux, Solaris, Windows, AIX, HP-UX
Exadata Database Machine, Exadata Database Service on Cloud@Customer, Exadata Database on Dedicated Infrastructure Requires Enterprise Manager 13c Release 5 Update 17 (13.5.0.17) or higher |
| HeatWave MySQL Database Systems | All |
| Exadata Database Service on Cloud@Customer | Pluggable Databases 19c and above, and Non-Container Databases 12c and above |
Mouse hover over the icon for full details.
Table 2-2 Ops Insights Supported Configurations
| Categories | Features | OCI Autonomous Shared and Dedicated Databases | OCI Database Cloud Service Databases | Exadata Database Service on Dedicated Infrastructure | Exadata Database Service on Cloud@Customer | Agent- Monitored External Databases and Hosts (on-premises) | Enterprise Manager Databases and Hosts (on-premises) | HeatWave MySQL Database System |
|---|---|---|---|---|---|---|---|---|
| Capacity Planning | Database Capacity Planning |  *
|
|
|
|
|
|
|
| Host Capacity Planning |  |
*
|
*
|
|
*
|
|
 |
|
| SQL Warehouse | SQL Warehouse | |
|
|
|
|
|
|
| SQL Explorer | *
|
|
*
|
|
|
*
|
|
|
| SQL Insights | *+
|
|
*
|
|
|
*
|
|
|
| Exadata Insights | Exadata Insights | |
|
|
|
|
|
|
| Exadata Explorer | |
|
|
|
|
|
|
|
| Other | ADDM Spotlight | *+
|
|
|
|
|
|
|
| Database Performance | *+
|
|
|
|
|
|
|
|
| News Reports | |
|
|
|
|
|
|
|
| Warehouses | AWR Hub | *
|
|
|
|
*
|
*
|
|
| AWR Explorer | |
|
|
|
|
|
|
|
| AWR Hub Explorer | |
|
|
|
|
|
|
|
| Exadata Warehouse | |
|
|
|
|
|
|
- : Available
- : Not Applicable
- : Not currently supported
- *: Denotes additional information on availability
- +: Denotes Full Features availability
Multicloud Databases
Multicloud allows you to harness the strengths of different cloud platforms while mitigating risks. However, monitoring and analyzing databases in a multicloud environment introduces unique challenges, requiring specialized approaches and solutions. You can use Ops Insights features on your Oracle Databases running on the following cloud platforms:
- Oracle Databases running on AWS RDS: You can discover the Oracle Databases on AWS RDS as External Databases and enable Diagnostics & Management. For information, see Set Up OCI Observability and Management for AWS RDS Databases.
- Oracle Database@Azure: You can enable communication between Ops Insights and Oracle Database@Azure using a private endpoint and then enable Diagnostics & Management. For information, see OCI Ops Insights: Enable Ops Insights for Oracle Database@Azure.
Oracle Standard Edition Database Monitoring
Ops Insights allows you to analyze and monitor Oracle Database Standard Edition databases via Management Agent, Enterprise Manager or Private Endpoint. This gives your Standard Edition databases access to Capacity planning, SQL Insights, and SQL Explorer capabilities.
Table 2-3 Oracle Standard Edition Feature Availability for Ops Insights
| Feature | Availability |
|---|---|
| Capacity Planning | Available |
| SQL Insights | Available |
| SQL Explorer | Available |
| SQL Warehouse | Not Supported |
| Database Performance | Available
(ADDM widget not available) |
| ADDM Spotlight | Not Supported |
| AWR Hub | Not Supported |
| AWR Explorer | Not Supported |