9.7.1.4 ALTER METRICDEFINITION

Purpose

The ALTER METRICDEFINITION command controls various metric attributes.

Syntax

ALTER METRICDEFINITION metric_name [, metric_name ]... attribute_name = attribute_value [, attribute_name = attribute_value]...

ALTER METRICDEFINITION attribute_name = attribute_value [, attribute_name = attribute_value]... attribute_filters

Usage Notes

• In the command:

  • metric_name: Identifies a specific metric definition to alter.

  • attribute_filters: Identifies the metric definitions to alter by filtering according to attribute values.

  • attribute_name=attribute_value: Specifies an attribute setting:

    • The finegrained attribute controls whether the metric is enabled for fine-grained collection.

      Specify finegrained=enabled to enable the metric for fine-grained collection, or specify finegrained=disabled to disable fine-grained collection for the metric.

    • The streaming attribute controls whether the metric is included in the metric stream.

      Specify streaming=enabled to include the metric in the metric stream, or specify streaming=disabled to exclude the metric from the metric stream.

    • The retentionPolicy attribute specifies the retention policy for metric observations.

      When retentionPolicy=Default, the retention period for the associated metric is governed by the metricHistoryDays cell attribute. If retentionPolicy=Annual, the associated metric has a one-year retention period.

      By default, a subset of key metrics are retained for up to one year (retentionPolicy=Annual).

      To restore a metric to the original retentionPolicy setting defined in Oracle Exadata System Software, set the retentionPolicy attribute to an empty string (retentionPolicy='').

      However, regardless of the retentionPolicy setting, historical metric observations are purged automatically if the server detects a shortage of storage space for the metric history repository.

• By default, a set of key performance metrics is automatically enabled for fine-grained collection and automatically included in the metric stream. However, you can customize the finegrained and streaming attributes independently. In other words, you can enable a metric for fine-grained collection without including it in the metric stream. Likewise, you can include a metric in the metric stream when it is not in the fine-grained collection.

Example 9-26 Alter a Specific Metric Definition

This example shows the command to enable fine grained metric collection for the metric that shows the Ethernet network interface transfer rate (N_NIC_KB_TRANS_SEC).

DBMCLI> ALTER METRICDEFINITION N_NIC_KB_TRANS_SEC finegrained=enabled

Example 9-27 Alter a List of Metric Definitions

This example shows the command to disable fine grained metric collection for a listed set of metrics.

DBMCLI> ALTER METRICDEFINITION N_MB_SENT,N_MB_RECEIVED finegrained=disabled

Example 9-28 Alter Metric Definitions Using a Filter

This example shows the command to include in the metric stream all of the metrics specified by the attribute filter.

DBMCLI> ALTER METRICDEFINITION streaming=enabled WHERE name LIKE 'N_NIC.*'