Service Configurations

With service configurations all your Ops Insights configurations can be set in a single location. Service configurations also streamlines the process of adding tags to your Ops Insights resources, though standard tags, and automated tag application from on-premise Enterprise Manager resources.

Service configurations can be used to customize how Ops Insights behaves and what experience can be obtained on applications like Capacity Planning, filtering experience, and more. When setting up configuration values, these can be set at the compartment level, or set at the root compartment level to allow all the compartments to apply those values.

Note

Setting a custom value at the compartment level will override root compartment values for the active compartment if they exist.

To access service configurations, open the navigation menu, click Observability & Management, and then click Ops Insights. Under Administration, click Service configurations. Use Search and Filter to filter service configurations by criteria such as category, metric, applicable resource type, and override status.

The Service configurations page includes the following information:

  • Configuration: Name of the configuration item.
  • Category: Configuration category, such as customer controlled collections, OCI tags, alerting thresholds, or UI thresholds.
  • Metric: Metric associated with the configuration, if applicable.
  • Applicable resource types: Resource types to which the configuration applies.
  • Current value summary: Current value for the configuration.
  • Override status: Indicates whether the value is a custom value, inherited from the root compartment, or a default value.

Currently, service configurations offer the following customizable configurations:

  • Customer Controlled Collections: Allow you to manage the collection of certain items for their Ops Insights-enabled resources, allowing you to disable or enable certain collections for the entire tenancy or specific compartments.
    Note

    Service configurations is applicable for Autonomous AI Databases with Full Features, Cloud Service databases, Exadata Database Service on Dedicated Infrastructures, Exadata Database Service on Cloud@Customer databases, and Management Agent Cloud Service External Databases.

    This feature is not applicable for Basic features-enabled Autonomous AI Databases.

  • EM property to OCI tag mapping: Allows you to override the tag keys that get applied to Enterprise Manager (EM) resources
  • OPSI tag filters: These are filters that can be created and will be visible along with other Ops Insights out-of-the-box filter
  • Utilization Thresholds

Customer Controlled Collections

In order to prevent SQL-related data from reaching the cloud from Enterprise Manager, Ops Insights recommends that you configure the service configurations before creating the Cloud Bridge within Enterprise Manager.
Note

Service configurations requires that Oracle Enterprise Manager be at version 13.5 release 17 (13.5.0.17) or higher.
For service configurations to work with Enterprise Manager the following policy needs to be added in the top level compartment where the target is added:
Allow <groupForOciUserInEM> to read opsi-family in <topLevelCompartmentWhereTargetsAreAdded>
For detailed instructions on setting policies, see OCI Prerequisites: Set Up Groups, Users and Policies.

The following is a list of available customer controlled collections:

  • Database ADDM collection: Disables ADDM collection for Ops Insights enabled databases in the selected compartment. Disabling this collection will stop populating ADDM Spotlight.
  • Database ASH SQL collection: Disables SQL ASH Stats collection for Ops Insights enabled databases in the current scope. Disabling this collection will stop populating SQL Insights.
  • Database AWR collection: Disables AWR collection for Ops Insights enabled databases in the current scope. Disabling this collection will stop populating Capacity Planning AWR reports.
  • Database SQL plan collection: Disables SQL Plan collection for Ops Insights enabled databases in the current scope. Disabling this collection will stop populating the SQL plans within SQL Insights.
  • Database SQL stats collection: Disables SQL Stats collection for Ops Insights enabled databases in the current scope. Disabling this collection will stop populating SQL Insights.
  • Database SQL text collection: Disables SQL Text collection for Ops Insights enabled databases in the current scope. Disabling this collection will stop populating SQL text within SQL Insights.

Use the Actions menu for customer controlled collections to edit, clear, or delete configuration values.

  • Edit configuration values: Opens the Edit configuration values panel for the selected configuration. Update the available values, and then click Save changes. Changes are not persisted until you click Save changes. To disable a collection, select Disable..., and then click Save changes. To re-enable a disabled collection, deselect Disable..., and then click Save changes.
  • Clear configuration values: Removes any custom values for the selected configuration and leaves the configuration with no values. Parent or root compartment inheritance is not applied. In the confirmation dialog, click Clear.
  • Delete configuration values: Removes any custom values for the selected configuration and allows the default values, or parent or root compartment inheritance, to apply. In the confirmation dialog, click Delete.

EM Property to OCI Tag Mapping

Given the similarities between Enterprise Manager target properties and OCI tags, Ops Insights can automatically tag Enterprise Manager-based Ops Insights resources with their respective global target properties and user-defined target properties as free-form tags. However, the target property keys may not be exactly the keys desired for the free-form tag key; Ops Insights service configurations allows mapping the EM property keys to the desired free-form tag key.
Note

For more information on user defined target properties see MOS note 2778043.1.

Use the Actions menu for an OCI tag mapping to map Enterprise Manager property keys to OCI free-form tag keys for Ops Insights resources.

  1. On the Service configurations page, locate EM property to OCI tag mapping, click the Actions menu for the row, and then select Edit configuration values.
  2. In the Edit configuration values panel, enter the Enterprise Manager property key in the EM property field.
  3. Enter the corresponding free-form tag key in the Tag key field.
    Note

    User-defined target properties will have the format udtp_1.
  4. To add an additional tag mapping, click New tag.
    Note

    You can add up to five tag keys.
  5. After you enter the tag mappings, click Save changes.

Remove and delete custom tag key values

To remove custom tag key values without applying parent or root inheritance, select Clear configuration values in the Actions menu.

To delete any custom tag key values, removing all custom values and leave the configuration with the default values, allowing any parent or root inheritance to be applied, select Delete Configuration values in the Actions menu.

OPSI Tag Filters

Ops Insights allows the creation of out-of-the-box tag filters, upgrading the OCI tag filter experience. These filters are compartment specific, unless added at the root compartment level. By creating a simple configuration, you can choose up to 15 tag keys (either defined tags or free-form tags) which you would like to become first class filters. To configure new out-of-the-box filters:

  1. On the Service configurations page, locate OPSI tag filters, click the Actions menu for the row, and then select Edit configuration values.
  2. In the Edit configuration values panel, add defined and free-form tags:
    1. To add a defined tag, select the Tag namespace, Tag key, and specify a Filter label which will appear within the application user interfaces.
    2. To add a free-form tag, select None (free-form tag), Tag key, and specify a Filter label which will appear within the application user interfaces.
  3. To add a new filter, click New filter.
    Note

    Up to 15 filters are allowed to be added
  4. Once all desired tags have been entered, click Save changes.

Remove and delete custom tag filter values

To remove any custom tag filter values and leave the configuration with no values, not allowing any parent or root inheritance to be applied select Clear configuration values in the Actions menu.

To delete any custom tag filter values, removing all custom values and leave the configuration with the default values, allowing any parent or root inheritance to be applied select Delete Configuration values in the Actions menu.

Use Tags by Filtering and Grouping

Once the out-of-the-box tag filters are configured, they will appear within Capacity Planning for databases and hosts, as well as within Exadata Insights, allowing for convenient filtering and grouping options.

Utilization Thresholds

Service Configurations also includes utilization thresholds from Capacity Planning and Exadata insights, these thresholds are divided into two subcategories:

  • UI thresholds: Within Capacity Planning for database and host, as well as Exadata insights, the high and low thresholds are used to determine the utilization percent at which a resource is considered over or under utilized respectively. This configuration applies to the insights regions on the summary page as well as the utilization groupings on the insight filtering options on the metric-specific drill down pages.

    These impact the high/low thresholds used within the Ops Insights UI.

  • Alerting thresholds: Within Capacity Planning for database and host, as well as Exadata insights, the high and low alert thresholds are used to alert at a utilization percent at which a resource is approaching a status of over or under utilization respectively. This configuration applies to the insights regions on the summary page as well as the utilization groupings on the insight filtering options on the metric-specific drill down pages.

    These impact the DaysToHigh and LowUtilization metrics emitted to OCI monitoring.

These configurations can be filtered by Category, Applicable resource types, and Metric.