Thursday, August 31, 2023

#984 OCI Logging Analytics OOTB OIC Dashboards

Kudos to my colleague Valeria C. and the OCI Logging Analytics team for creating these compelling dashboards. These dashboards are based on the OCI Service Metrics relevant for OIC, and the OIC log data pushed to OCI Logging Service.

It's maybe a good idea to check out my previous posts on OCI Logging and OCI Logging Analytics, if you're totally new to this area -

OCI Logging Analytics

OCI Logging

Lig dĂșinn tosĂș, as we say in Ireland -   

The dashboards are available to you now, just log in to your OCI tenancy ->   

Let's kick the tyres - 

Oracle Integration: Health Overview

Note the first widget - Environments - this is fleet management in practice.

Environments refer to the individual OIC instances, the logs of which are being forwarded to OCI Logging Analytics. See the final summary section for details of how this happens.

These instances can be OIC Gen2 or OIC3 instances.

So the initial view I see, when opening the dashboard, is over multiple instances. I also have the ability to filter down to individual OIC instances - 

Note, the gen2 instance surfaces via its name, in my case, oicpm. The OIC3 instance is identified by its OCID.

Also note, one can filter on individual integrations as well - 

You select the time period that's relevant to you - 

and one can also activate auto-refresh

Finally, note the ability to drill into a widget - 

This is the Log Explorer view - you see the query behind the widget - 
'Log Source' = 'OCI Integration Activity Stream Logs' | stats distinctcount(Instance) as Instances by Identifier | sort -Instances 

You can play around with this and, if you're happy the result, save it as a new widget.

The query language is simple enough - check out the OCI Logging Analytics docs here.

Summa summarum - from the general to the particular!

Dashboard Widgets

This dashboard includes the following widgets - 

  • Environments - my OIC instance fleet
  • Integrations - number of distinct integrations that have been executed in the time period selected e.g. sync_SFDC_contact_to_ERP, createNewCustomer_Netsuite etc.
  • Integration Instances - Number of instance flows in the selected time period.
  • Instances in Error Hospital - number of errored instances available for re-submission.
  • Instances in Error Hospital - bar chart representation of the above.
  • Instance By Environments - see at a glance the work distribution over multiple OIC instances 
  • Instances By Integration ID - see at a glance the load distribution over integrations e.g. 30% of my flows are for the integration createNewOrder-Netsuite. Business is good!
  • Instances in Catch Fault - details instances where faults have been caught via OIC Fault Handlers.  
  • Number of Inbound Requests - number of request processed by the OIC engine - this will also include integrations called via local invoke
  • Inbound Request Processing Time P95 - see at a glance, how integrations are performing.
  • Number of Outbound Requests - check out the number of invokes made from OIC integrations e.g. the integration createNewCustomer_Netsuite invoking Netsuite.
  • Outbound Request Invocation Time - check out the performance of your outbound invokes.
  • Potential Issues - this is a very interesting widget that trawls the logs for potential issues - let's look at some - 

New Issues

Here we are trawling the logs for errors, faults etc.


These are issues/events that occurred only once and may point to anomalies.


Log entries with a similar pattern 

The Potential Issues widget is extremely useful for both reactive and proactive error monitoring.


This is a dashboard provided to you out of the box by OCI Logging Analytics. As you've seen already, many of the dashboard widgets are powered by queries one can view/edit in Log Explorer. Net, net, everything is configurable, from the widget names, to the underlying queries etc. Simply make a copy of the OOTB Dashboard and configure it to suit your specific needs - 

Oracle Integration Key Metrics

This dashboard is based on the OCI Service metrics for OIC.

Filtering is available, as in the previous dashboard - 

Configuration again is possible, just duplicate the dashboard and edit to suit your specific requirements. For example, integrations with Fusion ERP may be critical for you, so you can create a widget for that specific adapter. You could make this even more specific - the Fusion ERP adapter usage by a particular integration e.g. createOrderFusionERP.

Oracle Integration Time Taken Analysis

Here you see at a glance, how long integrations are taking to execute. This is very useful, as you immediately see the most time consuming integrations, based on the widget bubble size.

From this high level view, I can easily drill down to the individual instance flows -


Here you have 3 extremely useful dashboards, all you need to do is ensure your OIC logs are getting to OCI Logging Analytics. This is very simple, here we go -

  • Enable Logging for your OIC Instance - this is done via OIC management in the OCI Console -

Note the Log Name and Log Group - in my case - DEV_OIC_PM3_ActivityStream and OIC_DEV_PM3LogGroup

Now to OCI Logging Service - 
here we have a Service Connector that pushes the data to OCI Logging Analytics.

Note the log names and groups - 

As you can see, logs from 3 OIC instances are being pushed to the same log group. These 3 instances are on OIC3. The fourth log is for a gen2 instance. All of these logs are being forwarded to OIC Logging Analytics, via the Service Connector.

It's that easy - so get analysing!


No comments: