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; these can be found by navigating to Observability & Management, then Ops Insights, select Administration and click on Service configurations. 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.
The Service Configurations table shows at a glance what configurations are enabled to be customized:

Figure 8-1 Service Configurations Table

Service Configurations Table
  • Configuration: Name of the configuration item
  • Category: Customer controlled collections
  • Metric : N/A, applies to the resource instead of an specific metrics
  • Applicable resource types: Databases only
  • Current value summary: By default, it is set to Collections enabled, update the Service Configuration to disable, once disabled the status will change to Collections disabled
  • Override status
    • Custom values: The Service Configuration in this compartment has a specifically set value
    • Root compartment: The current configuration value comes via root compartment inheritance
    • Default values: Neither the compartment or the root compartment have any specific custom values
Currently Service Configurations offer the following customizable configurations:
  • Customer Controlled Service Collections: Allow you to manage the collection of certain items for their Ops Insights enabled resources, allowing you to disable/enable certain collections on tenants and/or specific compartments.
    Note

    Service Configuration, is applicable for Autonomous Databases with Full Features, Cloud Service databases, and Exadata Database Service on Dedicated Infrastructures. This feature is not applicable for basic feature enabled Autonomous Databases, Exadata Database Service on Cloud@Customer databases or Management Agent Cloud Service External Databases.
    • 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 Warehouse.
    • 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 Warehouse.
    • 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 Warehouse and SQL Insights.
  • 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-box filter

Customer Controlled Service 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.

To modify a customer controlled Service Collection, open the desired customer controlled Service Collection, and select Disable collection for Ops Insights, this will disable the collections for that particular service. Once complete, click on Save Changes to save the configuration.Service Configuration customizable options

To re-enable, select the Service Configuration you wish to edit and deselect Disable collection for Ops Insights, this will enable the collections for that particular service. Once complete, click on Save Changes to save the configuration.

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.

Figure 8-2 EM Property to OCI Tag Mapping

EM Property to OCI Tag Mapping showing the tag creation
  1. Within Service configurations click on EM property to OCI tag mapping
  2. Enter the Enterprise Manager property key under EM Property.
  3. Enter the free-form tag equivalent of your choosing under Tag Key.
    Note

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

    Up to 5 tag keys are allowed.
  5. Once all desired tags have been entered, click Save changes.

Remove and delete custom tag key values

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

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.

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-box filters:

Figure 8-3 OPSI Tag Filters

OPSI Tag Filters with two filters created
  1. Within Service configurations click on OPSI tag filters
  2. Add defined and/or 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 on 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.

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.

Use tags by filtering and grouping

Once the out-of-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.

Location of tags within Capacity Planning

This image shows the location of the tags within Capacity Planning, note these are the same tags created in the sample image above.

Figure 8-4 Capacity Planning Tag Location

Capacity Planning Tag Location

Location of Filter Tags Within Ops Insights

This image show the location of the filter tags within Ops Insights, note these are the same tags created in the sample image above.

Figure 8-5 Location of Filter Tags Within Ops Insights

Location of Filters Within Ops Insights