Contributors: Chris Gurley, Vamshidhar Pasham, Santiago Bravo
OCI Operations Insights, (OPSI), part of the Oracle Cloud Observability and Management platform, has new features that help gather, analyze and plan for enterprise growth. In essence, it helps perform data-driven capacity planning and performance management thereby reducing enterprise capital expenditure and improve applications throughput. As we continue to introduce more capabilities and improve the OPSI experience, this blog highlights key additions.
ADDM Spotlight provides powerful visualizations of the Automated Database Diagnostic Monitor (ADDM) findings aggregated over longer periods of time such as a week, month or business cycle. These rich visualizations help identify anomalies in database performance faster and eliminate resource bottlenecks. To increase performance and reduce unplanned downtime, try out ADDM Spotlight in your own data center or in the cloud. ADDM Spotlight is available with our premier on-premises solution, Oracle Enterprise Manager (EM), as well as OPSI service. The blog Oracle Cloud Observability and Management platform covers this capability in more detail.
OPSI service can now generate weekly News Reports of the status of managed environments and workloads. The reports summarize the weekly resource utilization (high utilization and big changes in utilization over the prior week) as well as changes in the inventory, across databases, hosts, and Exadata systems. The reports are sent via email to a custom list of recipients using Oracle Notification Service (ONS).
Early last year, OPSI began supporting Oracle Base Databases and Exadata Database Service on Dedicated Infrastructure (ExaDB-D). Building on this, customers can now configure the data collections to be performed via the secure database connection protocol, TCPS. The wallet types PKCS#12 and Java Key Store (JKS) are now supported. To learn more about how to configure cloud database to connect via TCPS, review the blog TCPS support for cloud databases for OCI Database Management and the Add a Cloud Service Database technical content topic.
OPSI service now supports AutoML forecasting within Capacity Planning and Exadata Insights. AutoML leverages Oracle Data Science service capabilities to enhance the forecasting experience of existing Operations Insights users across database, host and Exadata resources. Below is an example of an AutoML generated forecast for a host CPU usage.
For more details on this feature, see the recent blog released: Single-click AutoML forecasting for complex workloads.
OPSI allows you to perform resource analysis on targets managed by EM, such as databases and hosts, including Engineered Systems. Starting with EM 13.5 Release Update 9 (22.214.171.124), EM began supporting an updated Cloud Exadata model for Exadata Cloud at Customer. Exadata on Dedicated Infrastructure support specifically started with EM 13.5 Release Update 14 (126.96.36.199). With these updates, the OPSI service is able to analyze data from these engineered systems type of targets. OPSI can now model Cloud VM Clusters for purposes of Capacity Planning, grouping databases and hosts (database VMs) by VM cluster and for use in SQL Warehouse.
Operations Insights demo mode can now be run within the Oracle LiveLab's sandbox tenancy, as shown in the figure below. With this enhancement, users are not required to add any policies within their own tenancy or subscribe to the London region (or even possess a tenancy at all). Now, within minutes, users can enable demo mode and start test-driving the latest OPSI features! Visit the Oracle LiveLabs for OPSI to get started.
In March of 2023, the Autonomous Database Full Feature support in OPSI was released for OCPU-based Autonomous Databases. The “full feature” support enables the use of SQL Explorer and ADDM Spotlight, with several exciting additions planned in the coming months. This support has now been extended to also cover ECPU-based Autonomous Databases. The SKU for this new offering is B97140 - Operations Insights for Oracle Autonomous Databases - Full.
OPSI Capacity Planning for hosts now supports AIX hosts that are managed targets in EM. AIX hosts can be added to OPSI using EM’s Cloud Bridge.
OPSI service support for External Database and Host via the OCI Management Agent is now available in the US Gov (OC2) and US DoD (OC3) realms. With this enhancement, we have also extended US Gov (OC2) and US DoD (OC3) realms support for EM managed resources including External Database, Host, and Exadata systems (including Database Machines, Exadata Database Service on Dedicated Infrastructure, and Exadata Database Service Cloud at Customer). On-premises customers now can leverage the Exadata Insights, Capacity Planning, SQL Warehouse, and ADDM Spotlight features in these realms. Additionally, support for Oracle Base Databases and Exadata Database Service on Dedicated Infrastructure (via private endpoint) is now available in both OC2 and OC3 realms, configured for either TCP or TCPS based connection protocols.
For more information on the new features see:
To learn more about Operations Insights capabilities, visit:
Not yet a customer? Sign up for an Oracle Cloud Infrastructure trial account!
Daniela has a background in Oracle Observability and Management solutions product management, training, and curriculum development. She currently manages the observability and management user assistance development team, focusing on optimizing the end user experience with our products and various types of technical content.