Actionable Insights

You can receive implementable Actionable Insights based on News Reports in a JSON format. These insights can be used to further automate tasks on monitored resources, for example: increase CPU, Memory based on capacity insights, and add queries based on SQL insights information to optimize database query.

Create an Actionable Insight

To create Actionable insights, from the Ops Insights menu navigate to Administration and click on Actionable insights. This will load the Actionable Insights administration page.

Click on the Create actionable insights button, to open the Create actionable insights slide-out.
Enter a name, description, compartment, select if you need to include child compartments, frequency (daily or weekly), and the day of the week that the actionable insights will be generated and sent on.

Select the insights you wish to receive:

Insight	Category	Description
New highs	Capacity planning	Resources that reached a new recorded high utilization level last week.
Big changes	Capacity planning	Resources with usage increase and decrease exceeding +/- 25% over the prior week.
Degrading SQL by database	SQL insights	Database list with degradation based on different insights
Degrading SQL details by database	SQL insights	SQL list that had the biggest degradation by average latency change.
Degraded plan changes by SQL Id	SQL insights	Plan changes (by estimated database time) that resulted in degradation in average latency across the database instances over last week.
Databases with invalidation storms	SQL insights	Top databases with the invalidation storms by invalidation rate
Databases with cursor sharing issues	SQL insights	Top databases with cursor sharing issues by excess hard parse CPU time
SQL with cursor sharing issues	SQL insights	Top 50 SQL with cursor sharing issues by excess hard parse CPU time

Select the appropriate notifications service topic. Alternatively you can create a new topic, by clicking on Create new topic. This will take you to the Create new topic section of Ops Insights.
Optional step: Click on Show advanced options to add tags to the resource. Once tags have been entered click on Add tags. For additional information on tags see: Overview of Tagging. This will allow tags defined for a report to filter resources that are included in the analysis.
Once all information has been entered and verified click on Create Actionable insight. The Actionable insight will now be visible in the Actionable insights administration page.

Additional Actions with Actionable Insights

Maintenance is an important activity for all Actionable Insights, the following is a list of maintenance actions that can be done:

Enable/disable an Actionable Insight

From the Administration page, select the Actionable insight you wish to enable or disable.
Click on the Actions menu button and select either Disable or Re-enable.
Click on the Disable or Re-enable button in the confirmation pop-up.

Move a Resource

From the Administration page, select the Actionable insight you wish to move to a different compartment.
Note

Changing an Actionable insight to a different compartment will NOT modify the resources that are in scope of the report. It will only change the report to a new compartment.
Click on the Actions menu button and select the Move resource button.
In the Move resource pop-up, select the new compartment for the Actionable insight resource and click the Move resource button.

Edit an Actionable Insight

To edit an Actionable insight resource, locate the insight to be edited in the administration page, click the vertical ellipses, and the click on Edit Actionable insight.
Perform changes to be made in the slide out menu.
Once all changes have been made click on the Save changes button.

Add Tags

To add tags to an Actionable insight, locate the insight to be edited in the administration page, click the vertical ellipses, and the click on Add tags.
You can Import standard tags by clicking the button, or manually add the standard tags by entering the tag name, key, and value
Once all tags have been added click on the Apply tags button.

Sample Payloads

The following are sample JSON payloads for Actionable insights:

New highs for databases sample:

{
  "newHighsDb": [
    {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko",
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb",
      "resourceId": "ocid1.autonomousdatabase.oc1.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf",
      "displayName": "db name 01",
      "resourceValue": 101.0,
      "resourceMetric": "STORAGE",
      "projectedUtilization": 102.0
    }
  ]
}

Big changes for databases sample:

{
  "bigChangesDb": [
    {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko",
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb",
      "resourceId": "ocid1.autonomousdatabase.oc1.phx.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf",
      "displayName": "db name 01",
      "resourceValue": 101.0,
      "resourceMetric": "STORAGE",
      "projectedUtilization": 102.0
    }
  ]
}

Degrading SQL by database sample:

{
  "degradingSqlByDb": [
    {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko", 
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb",
      "resourceId": "ocid1.autonomousdatabase.oc1.phx.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf",
      "displayName": "db name 01",
      "invalidationStormCount": "6",
      "cursorSharingDuplicatesSqlCount": "2",
      "avgDailySqlCount": "104",
      "avgActiveSessions": "8.51",
      "degradingSqlCount": "1",
      "newSqlCount": "23"
    },
     {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko2",
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb2",
      "resourceId": "ocid1.autonomousdatabase.oc1.phx.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf2",
      "displayName": "db name 02",
      "invalidationStormCount": "7",
      "cursorSharingDuplicatesSqlCount": "2",
      "avgDailySqlCount": "105",
      "avgActiveSessions": "8.52",
      "degradingSqlCount": "2",
      "newSqlCount": "24"
    }
  ]
}

Database with highest invalidation storm sample:

{
  "databaseWithHighestInvalidationStorms": [
    {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko",
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb",
      "resourceId": "ocid1.autonomousdatabase.oc1.phx.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf",
      "displayName": "db name 01",
      "avgDailySqlCount": "222.50",
      "invalidationStormCount": "8",
      "invalidationAvgPct": "59.79",
      "invalidationMaxPct": "74.05"
    }
  ]
}

Most impacted database by cursor sharing duplicates sample:

{
  "mostImpactedDatabaseByCursorSharingDuplicates": [
    {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko",
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb",
      "resourceId": "ocid1.autonomousdatabase.oc1.phx.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf",
      "displayName": "db name 01",
      "cursorSharingDuplicatesSqlCount": "33",
      "duplicateSqlMaxCount": "9",
      "duplicateSqlCpuParseSecs": "1.634"
    }
  ]
}

Top SQL by cursor sharing issues sample:

{
  "topSqlByCursorSharingIssues": [
    {
      "opsiId": "ocid1.opsidatabaseinsight.oc1..qazxswed7zr6rfvbgt6yhnmjui6asdf4ikmjuy5xdogv5rfvbgtyhnmjuiko",
      "tenantId": "ocid1.tenancy.oc1..tgbnhyujmj4ato2edcvfr7lbh5a3f46wsxcderf7yhnmju7ikmnj6bs2r6gtr",
      "compartmentId": "ocid1.compartment.oc1..dhrftgyh2qwertyuiopas7yhnbgtrfvc2ujmnhytg5qazxswedcvfrtgb",
      "resourceId": "ocid1.autonomousdatabase.oc1.phx.abwsxcderf7d5sncqtlnfak4eynlmedcvfrtgbnsdwwuhjm5iuytrewqasdf",
      "displayName": "db name 01",
      "sqlId": "0t73f1234u7q9",
      "cpuTimeSecs": "662.731"
    }
  ]
}

Oracle Cloud Infrastructure Documentation