12 Metric Views

This chapter provides a description of each metric view and its columns. It contains the following sections:

For examples of how to use views, see Chapter 20, "Examples".

12.1 MGMT$METRIC_CATEGORIES

The MGMT$METRIC_CATEGORIES view displays the list of classes and categories to which the metric belongs. It can be used to classify the metric based on the class (such as service or functional) and category within the class (such as security or configuration under functional class or usage or performance under service class).

Table 12-1 MGMT$METRIC_CATEGORIES

Column Description

TARGET_TYPE

Defines the target type of the metric being categorized

TYPE_VERSION

Defines the version of the target type

METRIC_NAME

Defines the name of the metric

METRIC_COLUMN

For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, then the value in this column is a single space.

METRIC_GUID

A unique ID for the metric

METRIC_CLASS_NAME

Name of the metric class to which this metric belongs

METRIC_CATEGORY_NAME

Name of the category of the metric in the class

METRIC_CATEGORY_NLSID

The NLS ID of the category which is used by Enterprise Manager to translate the name to different languages

12.2 MGMT$METRIC_COLLECTION

The MGMT$METRIC_COLLECTION view provides the metric thresholds details, frequency, upload policy, and thresholds per target.

Table 12-2 MGMT$METRIC_COLLECTION

Column Description

TARGET_NAME

Target where the metrics will be collected

TARGET_TYPE

Defines the set of metrics that are applicable for the target

TARGET_GUID

The unique id of the target

METRIC_NAME

Name of the metric

METRIC_COLUMN

For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, then the value in this column is a single space.

WARNING_OPERATOR

The operator for the warning threshold. This is used in the reporting environment to create a line on the graph representing the warning threshold appropriately.

Possible values:

  • 0 - GT

  • 1 - EQ

  • 2 - LT

  • 3 - LE

  • 4 - CONTAINS

  • 5 - NE

  • 6 - MATCH : regular expression

CRITICAL_OPERATOR

The operator for the critical threshold. This is used in the reporting environment to create a line on the graph representing the critical threshold appropriately.

Possible values:

  • 0 - GT

  • 1 - EQ

  • 2 - LT

  • 3 - LE

  • 4 - CONTAINS

  • 5 - NE

  • 6 - MATCH : regular expression

WARNING_THRESHOLD

Value for the warning severity

CRITICAL_THRESHOLD

Value for the critical severity

OCCURENCE_COUNT

The number of occurrences of a warning, critical, or clear severity before a severity record is generated

WARNING_COUNT

The number of consecutive times a metric value has exceeded the warning threshold

CRITICAL_COUNT

The number of consecutive times a metric value has exceeded the critical threshold

12.3 MGMT$METRIC_ERROR_CURRENT

The MGMT$METRIC_ERROR_CURRENT view associates current metric errors pertaining to a metric.

Table 12-3 MGMT$METRIC_ERROR_CURRENT

Column Description

TARGET_NAME

Name of the target for which the metric collection error occurred

TARGET_TYPE

Target type defines the set of metrics that are applicable for the target

TARGET_GUID

The unique ID of the target for which the metric collection error occurred

METRIC_NAME

The underlying metric for which the metric collection error occurred

METRIC_GUID

A unique ID for the metric. It can be used to associate metric information with metric data information during reporting

METRIC_LABEL

User display name of the metric for which the error occurred

COLL_NAME

Name of the collection collecting the metric for which the error occurred

COLLECTION_TIMESTAMP

Time when the collection error occurred

ERROR_TYPE

Indicates the type of error that happened during the collection of the metric

Possible values:

  • ERROR

  • WARNING

ERROR_MESSAGE

Text of the error message

12.4 MGMT$METRIC_ERROR_HISTORY

The MGMT$METRIC_ERROR_HISTORY view displays the history of metric collection errors.

Table 12-4 METRIC_ERROR_HISTORY

Column Description

TARGET_NAME

The name of the target for which the metric collection error occurred

TARGET_TYPE

Target type defines the set of metrics that are applicable for the target

TARGET_GUID

Target GUID of the target for which the metric collection error occurred

METRIC_NAME

Name of the metric for which the error occurred

METRIC_GUID

A unique ID for the metric. It can be used to associate metric information with metric data information during reporting

METRIC_LABEL

User display name of the metric for which the error occurred

COLL_NAME

Name of the collection collecting the metric for which the error occurred

COLLECTION_TIMESTAMP

The time when the collection error occurred

ERROR_TYPE

Indicates the type of error that happened during the collection of the metric

Possible values are:

  • ERROR

  • WARNING

ERROR_MESSAGE

Text of the error message